The Location Breakpoints Tab

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

  1. From the Edit menu, click Breakpoints.

    The Breakpoints dialog box appears.

  2. Choose the Location tab.

  3. Click the drop-down arrow next to the Break At text box.

  4. From the menu that appears, select the current statement location.

  5. 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

  1. 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.

  2. Click OK.

To set a breakpoint at the beginning of the current stored procedure

  1. In the Location tab, click the drop-down menu next to the Break At box.

  2. From the menu, choose the current stored procedure name that appears.

  3. Click OK.

To set a breakpoint at the beginning of a stored procedure

  1. In the Location tab, type the stored procedure name directly into the Break At text box.

  2. 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

  1. In the Location tab, select the location breakpoint in the Breakpoints list.

  2. Edit the location that appears in the Break At text box.

  3. Click OK.