Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 SQL Debugger

Author  Topic 

mwenda
Starting Member

1 Post

Posted - 2004-12-01 : 05:28:05
Hi guys
I have been having a problem with sql Debbugger tool.
Whenever I try and debug a stored proc the debugger runs all the way to the end of the procedure, meaning I cannot step through the code.

I have tried the stuff MS have so eloquently put in their troubleshooting topic on books online still get the same results.

I'd be glad if anyone could tell me how to go about this.

Ps> am running windows XP
thanks

MG

Wanderer
Master Smack Fu Yak Hacker

1168 Posts

Posted - 2004-12-01 : 07:18:55
MG,

Have yuo tried debugging in Query Analyzer? (assuming you are using sql 2000)
If you open the pbject browser (f8), then naviagte to your DB, then to stored procedures, then to your stored procedure. Right click on the SP, debug, and give approprite value. You can then step through the code.

HTH

*##* *##* *##* *##*

Chaos, Disorder and Panic ... my work is done here!
Go to Top of Page
   

- Advertisement -