December 8, 2005 at 10:30 am
I'm trying to debug a stored procedure in SQL server 2000 and I can't get the debugger to stop at the first executable command. Also if I stop the debugger and put in a breakpoint and then re-run the procedure the debugger doesn;t stop at the breakpoint. I've been through all the suggestestions in the help file. Anyone got any suggestions?
December 9, 2005 at 6:42 am
December 9, 2005 at 8:16 am
I had the same problem when I attempted to use the debugger. The solution that I found was making sure that my local copy of SQL Server Client tools (eg. Query Analyzer) had the current service packs installed to match the server. After updating the service packs I was able to get the debugger to step through the code.
A sidenote on a separate issue that sometimes occurs is that you need to have permissions to the 'sp_sdidebug' in the master database for the server you are trying to debug on.
Good Luck.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply