Re: Debug stored procedure in query analyzer

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

That doesn't explain why debug works on some computers and not others, with
the same stored procedures.
--
Carole


"Narayana Vyas Kondreddi" wrote:

> You may have to specify date parameter values in a specific format. For
> example, see:
> http://groups-beta.google.com/group/comp.databases.ms-sqlserver/browse_thread/thread/31e4a338e1b6d5d0/90f1164645c4a4f9?lnk=st&q=Invalid+character+sql+debugger&rnum=2&hl=en#90f1164645c4a4f9
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
>
>
>
> "CDuttlinger" <h2oPower@xxxxxxxxxxxxxxxx> wrote in message
> news:6E2C1A97-A747-4BC6-979B-CE090C67B6A4@xxxxxxxxxxxxxxxx
> > 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: Unable to view system stored procedures from .NET IDE and unable to debug SQL
    ... But what is the reason for the debug problem I mentioned below? ... try to step into a stored procedure in the Northwind database, ... Run SQL server setup or contact database ... I can't see any system stored procedures in master. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Debug stored procedures with VB6
    ... I can at last debug stored procedures (I can't debug procedures since more ... "Val Mazur" a écrit dans le message de ... > In a Query Analyzer you should open Object Browser, ...
    (microsoft.public.vb.database.ado)
  • RE: SP and Trigger debugging
    ... It is more feasible if you debug the stored procedures and Triggers from the ... If any way you need IDE to debug the stored Procedure VS.Net ...
    (microsoft.public.sqlserver.programming)
  • Re: No System stored procedures in MSDE install
    ... stored procedures from the .NET IDE because there's all these DCOM ... Analyzer to debug your stored procedures, ... Developer edition of SQL Server if you don't already have a full ...
    (microsoft.public.sqlserver.msde)
  • Urgent: Unable to debug stored procedure on Windows 2003 with VS.Net 2003
    ... Previously I have debugged stored procedures with VS.NET 2002 on Windows ... I know that in order to debug a stored procedure, ... located via Solution-Properties - Configuration properties - Debugging. ...
    (microsoft.public.dotnet.framework.aspnet)