INF: Advanced Debugging of SQL Server Procedures

ID: Q163451

The information in this article applies to:

Microsoft SQL Server version 6.5

SUMMARY

This article describes the method of debugging a stored procedure that invokes an extended stored procedure, while also debugging that extended stored procedure.

MORE INFORMATION

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

Q156096 : INF: Tips for Debugging Stored Procedures from VC++

Q156099 : INF: 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:

Follow the steps outlined in Q156099. Make sure SQL Server is up and running under the debugger, and that your breakpoints are properly set.

Start a second session of Visual C.

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.

Follow the steps outlined in Q156096 to debug the stored procedure.

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

Additional query words:


Keywords          : kbprg SSrvProg 
Version           : 6.5
Platform          : WINDOWS 
Issue type        : kbhowto

Last Reviewed: April 8, 1999