About Using Breakpoints with SQL Source

Feature Only in Enterprise Edition   This feature is supported only in Visual C++ Enterprise Edition. For more information, see .

Breakpoints tell the debugger where or when to break execution of SQL source code. You can set breakpoints in either the source window or the Call Stack window. A red dot identifies breakpoints in the source code.

When you halt the SQL code at a breakpoint, you can examine the state of your program, step through your code, and evaluate variables using the debugger windows.

The Breakpoints dialog box displays a list of all breakpoints set in the project. Use the Location tab on this dialog box to set, remove, disable, and enable SQL source breakpoints.

Note   The SQL debugger only supports location breakpoints.

When you close a project, the debugger saves all breakpoints you have set as part of the project information. The next time you open the project, the breakpoints remain as you left them.

The debugger also provides quick methods for setting location breakpoints without using the Breakpoints dialog box.