Debugging Stored Procedures with Query Analyzer

I have the following problem:
When trying to debug a stored procedure with query analyzer it does not stop at the first line of code. Instead it runs throug the whole procedure and I cannot stop it! Am I missing something?
Without being able to interrupt the procedure I want to debug, the debugger is useless...
Regards
Stephan
.

Relevant Pages

  • Re: SP and Trigger debugging
    ... switches, error code ... Query Analyzer has a debugger. ... if you have to debug a trigger, make a procedure that holds the insert, ...
    (microsoft.public.sqlserver.programming)
  • (2000) Unable to connect to debugger
    ... I have three different SQL Server instances: ... When i try to debug a stored procedure in Query Analyzer, ...
    (comp.databases.ms-sqlserver)
  • (2000) Unable to connect to debugger
    ... I have three different SQL Server instances: ... When i try to debug a stored procedure in Query Analyzer, ...
    (microsoft.public.sqlserver.connect)
  • Re: SQLdatasource delete with parameter output
    ... Also you can possibly debug and step into your stored procedure. ... @SiteProjectID Int, ... @MeasureID Int, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Debugging nested Stored Procedures
    ... With SQL Server 2000 stored procedure debugging, ... this feature only works from SQL Server Query Analyzer. ... right-click on the stored procedure and select 'Debug'. ... Debugger' use to provide this but the product is no longer. ...
    (microsoft.public.sqlserver.tools)
Loading