Debugging in SQL Query Analyzer 1

[esmithbda]

When I right click on a stored procedure in Query Analyzer and select "Debug", I can enter the data and then it runs - but all of the documentation that I find on it says that it should stop at the first executable line and then wait for instructions from me (step into, step over, etc).

But instead, mine just executes and won't even let me set breakpoints (well, I can set them, but it ignores them).

I know that there is an issue with SP3/4 SQL Server and not having the same SP on the machine that has the Query Analyzer install, but that doesn't appear to be the case here.

Any suggestions as to what might cause this and how to resolve it? The searches (and reading of the Tek-Tips FAQ on this) yielded results and I tried those suggestions, but it still won't debug for me.

 

[TysonLPrice]

Run this in the database fist:

sp_sdidebug 'legacy_on'

 

[esmithbda]

aha - that got me to at least see some error messages.

It said something along the lines of checking to see if I had the sqldebug.exe program (that might not be the exact name, this is just off the top of my head), and then that at least let me do more searches to see what the issue is.

I ran across a few things noting that the changes I would need to make were not recommended for a live server, and while this one is just used in-house, I would rather be unable to debug on it rather than open up a sercurity issue.

Thanks for helping me to narrow it down.