Microsoft KB Archive/163451

= INF: Advanced Debugging of SQL Server Procedures =

Article ID: 163451

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q163451



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:


 * 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.

Keywords: kbhowto kbprogramming KB163451

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.