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