Enabling and disabling breakpoints (SQL Stored Procedure Debugger)

Rather than deleting a breakpoint, you can disable it so that it does not stop execution of the stored procedure. When you disable a breakpoint, it remains in the Breakpoints view. To have your stored procedure stop on a breakpoint that you have disabled, select and enable it. The advantage of disabling a breakpoint instead of deleting it is that you do not have to find the location in the source to set the breakpoint again. In addition, a disabled breakpoint saves any extra settings that you may have made to the breakpoint.

There are two indicators to the left of a set breakpoint. To the far left is a check box which indicates if the breakpoint is enabled. Enabled breakpoints are indicated with a check mark in this check box, while disabled breakpoints are indicated with no check mark in the check box. When a breakpoint is disabled, you can choose Enable from its pop-up menu in the Breakpoints view or editor, and the Disable menu item is not available. When a breakpoint is enabled, you can choose Disable from its pop-up menu and not Enable.

You can enable or disable a single breakpoint from the Breakpoints view, as follows:

Click the check box to the far left of the breakpoint you want to enable or disable. If the check box contains a check mark, the breakpoint is enabled. If it does not contain a check mark, it is disabled.
Right-click on the breakpoint you want to enable or disable and select Enable or Disable from the pop-up menu.

You can also disable all breakpoints. To do this, click the Skip All Breakpoints toggle button. This will temporarily disable all breakpoints. To re-enable all breakpoints (except those that you had specifically disabled via the Disable Breakpoint action), click the Skip All Breakpoints toggle again to cancel it.

Related tasks

Using breakpoints
Removing breakpoints