What Is Direct Database Debugging?

Feature Only in Enterprise Edition   SQL source code debugging is supported only in Visual C++ Enterprise Edition. For more information, see Visual C++ Editions.

You can debug a stored procedure directly. Direct database debugging is useful when the stored procedure is testable as a stand-alone procedure and you simply want to determine if the stored procedure works correctly.

Direct database debugging bypasses the need for a supporting ODBC application that calls the stored procedure. You can type in arguments before the stored procedure runs.

For more information on how to quickly prepare for direct database debugging, see Creating a Direct Database Project.

Note   If your application is a long series of interactions between program code and stored procedure results, you should consider using the standard application SQL debugging process.

To do direct database debugging

  1. In the Data View pane, select a stored procedure.

  2. Click the right mouse button in the Data View pane.

    – or –

    Click the right mouse button in the source code window.

  3. Click Debug.

    The debugger pauses execution at the first statement.