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
 General SQL Server Forums
 New to SQL Server Programming
 debuging stored procedures

Author  Topic 

ronin2307
Posting Yak Master

126 Posts

Posted - 2007-03-28 : 11:25:59
hi,
i have a SQL2000 server which i am managing using the 2005 client.
anyway... i have a stored procedure which is not behaving the way i expected it to and i would like to debug it, sort of like debugging in visual studio.
I would like to be able to monitor the variables as they are going through the stored procedure.
Is that possible and if so, how?
Thanx

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2007-03-28 : 11:51:53
searching here for "debug stored procedure" turned up the following amongst many others...how about you try repeating the exwrcise at your end

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=5056&SearchTerms=debug,stored,procedure
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=8517&SearchTerms=debug,stored,procedure
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=3619&SearchTerms=debug,stored,procedure
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=15070&SearchTerms=debug,stored,procedure
Go to Top of Page

ronin2307
Posting Yak Master

126 Posts

Posted - 2007-03-28 : 12:13:37
exercise repeated... tried to use the debugger but it just runs through the code without ever stopping. it seems to be ignoring breakpoints.
what am i doing wrong?
Go to Top of Page

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2007-03-30 : 06:55:31
see below for more info...

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80879
Go to Top of Page
   

- Advertisement -