Debugging an Extended Stored Procedure
Debugging an extended stored procedure is similar to debugging a DLL. For general information about debugging DLLs, see the development environment and debugger vendor documentation.
To debug an extended stored procedure DLL by using Microsoft Visual C++
- In Microsoft® Windows NT®, stop the SQL Server Service by using SQL Server Service Manager or Control Panel.
- Open the project that builds the extended stored procedure DLL, and build it.
- Copy the extended stored procedure DLL to the SQL Server \Binn directory (C:\Mssql7\Binn by default).
- On the Project menu, click Settings.
- In the Project Settings dialog box, click the Debug tab.
- In the Category list, click General.
- In the Executable for debug session box, enter the path and file name of the Microsoft SQL Server™ executable file (for example, C:\Mssql7\Binn\Sqlservr.exe). For information about sqlservr arguments, see sqlservr Application.
- In the Category list, click Additional DLLs.
- In the Local module name box, enter the names of any additional DLLs you want to debug.
- Click OK to store the information in the project.
- Set breakpoints as required in the DLL source files or on function symbols in the DLL.
- On the Build menu, click Go to start the debugger.
See Also
sqlservr Application
(c) 1988-98 Microsoft Corporation. All Rights Reserved.