Debugging a stored proc

[danvlas]

Hello All,

Is there any reason that the debugger in QA is disabled?
I'm trying to use it, all the buttons show up, but only 'Go', 'Toggle breakpoint' and 'Remove All Breakpoints' are active.
'Step Into', 'Step Over', 'Step Out' and 'Run to Cursor' are disabled.

Any suggestions are highly appreciated.

TIA




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[Chopstik]

In Query Analyzer? Or are you using Visual Studio with it's debugger? If so, you may want to try the Visual InterDev forum for VS 6 or one of the .NET forums (depending on which one you need).

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill

 

[danvlas]

Query Analyzer.

Forgot to mention the server version: 2000




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[SQLSister]

http://www.tek-tips.com/faqs.cfm?fid=4314

if you go to the bottom there is a refernce to an article that talks about how to get the debugger to work. Me personally I find the debugger essentially worthless (it just is a bad implementation of a debugger). Your mileage may vary.

"NOTHING is more important in a database than integrity." ESquared

 

[Chopstik]

Not sure if this will help or not... I'm learning this myself today...

http://support.microsoft.com/kb/328151

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill

 

[nice95gle]

This might help

http://msdn2.microsoft.com/en-us/library/Aa937580(SQL.80).aspx

Good Luck

Well Done is better than well said
- Ben Franklin

 

[danvlas]

Thank you very much, I'll check the suggestions and I'll get back.




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[TysonLPrice]

Something to try, it may be in the links posted, is running sp_sdidebug 'legacy_on' where you are trying to debug.

The debugger is turned off by default. Then you may get into access issues. We also had to apply service pack 4 (I think that was it) to get it going.

After a number of mis-steps we got it working. I disagree with it being " essentially worthless". It's much better then print staements and also steps into triggers. You don't see that just looking at the code.