Re: Debugging Stored Procedures with Query Analyzer

On Wed, 23 Aug 2006 16:21:56 +0200, Stephan Zaubzer
<stephan.zaubzer@xxxxxxxxxx> wrote:

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...

There's always the old-school approach of adding temporary PRINTs
into the procedure, provided that you remember to take them out
afterward (or key them to some central flag, e.g. "if table X
contains record Y").
.