Feature Only in Enterprise Edition This feature is supported only in Visual C++ Enterprise Edition. For more information, see Visual C++ Editions.
With the SQL debugger, you can set location breakpoints:
You can disable and enable breakpoints on a statement line or in the Call Stack window. You can set or remove any breakpoint by using either the Breakpoints dialog box or the following quick procedures.
To set a breakpoint at a statement or the Call Stack window
A red dot appears in the left margin, indicating the breakpoint is set.
Note If you want to set a breakpoint on a statement extending across two or more lines, you must set the breakpoint on the first line of the statement.
To set a breakpoint at the beginning of a stored procedure
A red dot appears in the left margin at the beginning of the stored procedure, indicating that the breakpoint is set.
To disable a breakpoint
The red dot in the left margin changes to a hollow circle.
To disable all breakpoints
The red dots in the left margin change to hollow circles.
To enable a breakpoint
The hollow circle in the left margin changes to a red dot.
Note If you set more than one breakpoint on a line, and some breakpoints are disabled while others are enabled, a gray dot appears in the left margin to indicate multiple breakpoints with varying status. The first time you click the Enable/Disable Breakpoint toolbar button with the insertion point on that line, all breakpoints on the line become disabled, and the gray dot changes to a hollow circle. If you click the Enable/Disable Breakpoint button again, all breakpoints on the line become enabled, and the hollow circle changes to a red dot.
To remove a breakpoint using the Breakpoints dialog box
The red dot in the left margin disappears.
To remove a breakpoint in a window
The red dot in the left margin disappears.
Note If a line contains enabled and disabled breakpoints, the Insert/Remove Breakpoint button removes all enabled breakpoints. Disabled breakpoints are not affected.