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++

1. In Microsoft® Windows NT® 4.0, stop the SQL Server Service by using SQL Server Service Manager or Control Panel.
   
   
2. Open the project that builds the extended stored procedure DLL, and build it.
   
   
3. Copy the extended stored procedure DLL to the SQL Server \Binn directory (C:\Program Files\Microsoft SQL Server\Mssql\Binn by default).
   
   
4. On the Project menu, click Settings.
   
   
5. In the Project Settings dialog box, click the Debug tab.
   
   
6. In the Category list, click General.
   
   
7. In the Executable for debug session box, enter the path and file name of the Microsoft SQL Server™ executable file (for example, C:\Program Files\Microsoft SQL Server\Mssql\Binn\Sqlservr.exe). For information about sqlservr arguments, see sqlservr Application.
   
   
8. In the Category list, click Additional DLLs.
   
   
9. In the Local module name box, enter the names of any additional DLLs you want to debug.
   
   
10. Click OK to store the information in the project.
    
    
11. Set breakpoints as required in the DLL source files or on function symbols in the DLL.
    
    
12. On the Build menu, click Go to start the debugger.

See Also

sqlservr Application