Feature Only in Enterprise Edition This feature is supported only in Visual C++ Enterprise Edition. For more information, see Visual C++ Editions.
You can use the Location tab in the Breakpoints dialog box to set a location breakpoint:
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
The Breakpoints dialog box appears.
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
To set a breakpoint at the beginning of the current stored procedure
To set a breakpoint at the beginning of a stored procedure
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