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
– or –
Click the right mouse button in the source code window.
The debugger pauses execution at the first statement.