INF: Advanced Debugging of SQL Server Procedures

MORE INFORMATION

First, you may want to read the following articles in the Microsoft Knowledge Base:

• 156096 : INF: Tips for Debugging Stored Procedures from VC++
• 156099 : HOW TO: Debug an Extended Stored Procedure

Integrating the information in these articles is not difficult. However, you must understand that each is a separate debugging process. As such, you cannot perform both operations from the same debugging session. The Visual C/C++ product does not currently allow you to debug multiple processes in the same session.

Use the following procedure to make it work:

1. Follow the steps outlined in 156099. Make sure SQL Server is up and running under the debugger, and that your breakpoints are properly set.
2. Start a second session of Visual C.
3. Create a console project and add a data source to the project. You can think of this as a simple project. No source code files, just the ability to add the data source.
4. Follow the steps outlined in 156096 to debug the stored procedure.

Each debugging session allows you to debug that respective part of the scenario.