SQL ANALYZER DEBUGGER

[kissarmi]

Hello,

The anaylzer debugger isn't working properly. I right click in the object browser and choose debug, but the analyzer looks like it just runs through the stored procedure and gives a return value. The pane where the variables are displayed is shaded out with nothing displayed in it. I get a return value 0, which shows there aren't errors. Is there a switch or something else that needs to be set within the analyzer?

Thanks for any help.

 

[bikerboy718]

Its turned off by default. Try

Exec sp_sdidebug 'legacy_on'

With Great Power Comes Great Responsibility!!!

Michael

 

[bikerboy718]

If that does not work it may be that SQL Server is running under the local system account. It should be running on a domain account.

Also if SQL Server is running SP3 and your Query Analyzer is SP2 you could have this problem.


With Great Power Comes Great Responsibility!!!

Michael