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.