SQL Dialog Boxes

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

In addition to windows, the debugger uses a number of dialog boxes to control breakpoints, variables, threads, and exceptions.

Tip   To open the Breakpoints dialog box, use the Breakpoints command on the Edit menu. Use commands from the Debug menu to open the other debugger dialog boxes.

The following table describes the information displayed in the SQL debugging dialog boxes.

SQL Debugging Dialog Boxes

Dialog box Displays
Breakpoints All breakpoints assigned to your project. Use the Location tab in the Breakpoints dialog box to create new breakpoints. You must specify breakpoints by line number or stored procedure name. Do not use data or message breakpoints.
Exceptions Any exceptions that occur. These exceptions are related to the client application and do not refer to the execution of the SQL Server or SQL source.
QuickWatch Variables only. Use QuickWatch to quickly view locals or global variables, modify local variables, or add variables to the Watch window.
Threads Threads related to either the client application or the SQL code. SQL debugging provides a thread that allows you to switch between the SQL code you’re debugging and threads in the client application.