I cannot get the debugger in Enterprise Manager to work correctly. I would like to be able to step through a stored procedure but when I set a break point and run the code it the debugger does not stop at the breakpoint. This may help, all of the step buttons, restart and stop debugging are greyed out. I am not sure what I need to do to get the breakpoints and step buttons to work correctly.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Debugger
- Thread starter drallabs
- Start date
TysonLPrice
Programmer
The debugger is turned off by default. You may need to have your DBAs turn it on for you. One thing to try is to run:
sp_sdidebug 'legacy_on'
In the databse you are debugging on. However with things "greyed out" I don't think it is turned on. Windows SP5 (I think it was SP5) seems to have broke it also.
sp_sdidebug 'legacy_on'
In the databse you are debugging on. However with things "greyed out" I don't think it is turned on. Windows SP5 (I think it was SP5) seems to have broke it also.
When I try to execute sp_sdidebug, I get a message saying that the stored proc could not be found.
I tried to run sp_addextendedproc, but I don't know which argument to use for the second parameter of this special sttored proc. (It is supposed to be the DLL where the sp you are adding exists)
Anyone have any ideas? sp_sdidebug seems hardly documented at all.
- Status
Similar threads