The Location Breakpoints Tab
Feature Only in Enterprise Edition This feature is supported only in Visual C++ Enterprise Edition. For more information, see .
You can use the Location tab in the Breakpoints dialog box to set a location breakpoint:
On a specific statement in SQL source code.
At the start of SQL source code.
Note Except where noted, the following procedures work only within the context of the currently viewed SQL source.
To set a breakpoint at the current location
From the Edit menu, click Breakpoints.
The Breakpoints dialog box appears.
Choose the Location tab.
Click the drop-down arrow next to the Break At text box.
From the menu that appears, select the current statement location.
Click OK.
Note If you want to set a breakpoint on an SQL statement extending across two or more lines, you must set the breakpoint on the first line of the statement.
To set a breakpoint at another location
In the Break At text box on the Location tab, type a source-code line number (if the current location is in a source file). For source locations, type a period immediately before the line number.
Click OK.
To set a breakpoint at the beginning of the current stored procedure
In the Location tab, click the drop-down menu next to the Break At box.
From the menu, choose the current stored procedure name that appears.
Click OK.
To set a breakpoint at the beginning of a stored procedure
In the Location tab, type the stored procedure name directly into the Break At text box.
Click OK.
Note To set a breakpoint by typing the stored procedure name, two conditions are necessary: the current window must be focused on SQL source code from the same server and database as the stored procedure receiving the breakpoint, and you must be currently debugging.
To edit a location breakpoint
In the Location tab, select the location breakpoint in the Breakpoints list.
Edit the location that appears in the Break At text box.
Click OK.