Debug stored procedure in query analyzer

Trying to use Debug feature in query analyzer -- on some systems I get the
message

[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification

There's nothing wrong with the stored procedure. If I have this problem, it
happens with all stored procedures except those that have no parameters. If
there are no parameters, the message doesn't show, but debug still doesn't
work properly.

--
Carole
.

Relevant Pages

  • Re: Debug stored procedure in query analyzer
    ... You may have to specify date parameter values in a specific format. ... Vyas, MVP (SQL Server) ... > Trying to use Debug feature in query analyzer -- on some systems I get the ... > There's nothing wrong with the stored procedure. ...
    (microsoft.public.sqlserver.tools)
  • Re: Is sql server as good as access 97?
    ... Once you really get into using Query Analyzer for writing your ... Transact-SQL and for formulating 'queries' for exporting to your code, ... resulting stored procedure runs in a small fraction of the time it took to ... Unfortunately the database I am converting ...
    (microsoft.public.sqlserver.programming)
  • RE: Differences in execution times for a stored procedure
    ... If OleDb, ... "Vincent Keller" wrote:> I am trying to execute a time-consuming stored procedure in my application. ... > Are there some known performance differences in executing a query directly through Query Analyzer and through ADO.NET? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: "On Error Resume Next" in SQL Server
    ... When you are running your query in query analyzer, ... > would occur would be due to bad user input which does not ... > that my stored procedure will run to the end of the cursor? ...
    (microsoft.public.sqlserver.programming)
  • Re: Exception: The SqlTransaction has completed; it is no longer usabl
    ... > I hv encountered this exception 'The SqlTransaction has completed; ... returning around 9000 rows in a DataSet and back to the app. ... > When that exception is thrown, I tried running the same stored procedure ... > I was thinking if Query Analyzer can return data very quickly... ...
    (microsoft.public.dotnet.framework.adonet)