Terminating and suspending
There are a number of ways to end or suspend a debug session. Various methods are described below.
Terminate
Terminating results in an immediate end to a debug session, and the stored procedure that you are debugging runs to completion.
To terminate a debug session:
In the Debug view, select the debug project, target, or thread that you want to terminate. Do one of the following:
- Select Terminate from the workbench Debug menu.
- Right-click and select Terminate from the pop-up menu. Alternatively, you can select Terminate and Remove to terminate the session and remove it from the Debug view.
Note: If you right-click the debug target, choosing Disconnect from the pop-up menu will also result in termination of the debug session. The stored procedure you are debugging will not terminate.
To terminate all debug sessions, right-click in the Debug view and choose Terminate All from the pop-up menu.
If you have terminated one or more sessions and would like to remove them from the Debug view, right-click in the Debug view and choose Remove All Terminated from the pop-up menu.
Resume (Run)
If you are debugging a stored procedure which contains no active breakpoints, choosing to Resume suspended threads will result in an end of the debug session (ie. the stored procedure will run to completion and the debug session will terminate).
Note: When setting preferences, you can specify the number of seconds of inactivity before the procedure that you are debugging runs to completion. If there is no debug activity for this length of time, the procedure and debug session will terminate.