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
During a debug session, you can have a stored procedure run until
the end of it is reached or until an active breakpoint is hit.
Stepping through a stored procedure
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).