Controlling program execution and working with breakpoints
When debugging stored procedures, you can control program
execution by using breakpoints, or by issuing run and step commands.
About this task
To learn more about these actions, see the related topics.
Using breakpoints
A breakpoint causes the execution of a thread to suspend at the
location where the breakpoint is set.
Running a procedure during a debug session
During a debug session, you can have a routine (stored
procedure or function) run until the end of it is reached or until
an active breakpoint is hit.
Stepping through a routine
When a thread is suspended, the step controls can be used
to step through the execution of the stored procedure line-by-line
(assuming there is one statement per line).