sqldbgr is a command line utility that debugs stored procedures and triggers. You can:
Attach sqldbgr to a task
Set, enable, and disable breakpoints
Step through a task one line at a time
Step into and out of procedures
Detach sqldbgr from stored procedures or triggers once the debugging is complete
