Setting Up SQL Debugging
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

Setting Up SQL Debugging

In This Section

SQL Debugging Software Requirements
Lists the software requirements for SQL debugging.
Enabling SQL Debugging
Provides high-level instructions for enabling SQL debugging. This includes, running Remote Components Setup (which will install SQL debugging components on the server), setting up SQL Server permissions for debugging, configuring DCOM on the server for SQL debugging, and configuring DCOM on a workstation running Windows 2000 or Windows XP.
SQL Debugging Components
Lists the components needed for SQL server debugging.
Setting SQL Server Permissions for Debugging
Provides instructions on giving debugging access to SQL Server users. This includes specific instructions for Windows NT 4.0.
Configuring DCOM for SQL Debugging
Discusses configuring DCOM to allow remote users to attach the debugger to processes on servers. This includes security considerations, specific steps for configuring DCOM on Windows 2000 and Windows XP, and tips.
Installing a New Version of SQL Server After Enabling SQL Debugging
Recommends that you setup remote debugging again if you have installed a new version of SQL Server after enabling SQL debugging.
SQL Debugging Setup Errors and Troubleshooting
List issues you may encounter when setting up SQL debugging and solutions to those problems.

Related Sections

Debug Settings and Preparation
Covers the settings and preparation that you must perform to debug your program with the Visual Studio debugger.
Debugging SQL
Provides information on debugging SQL Server stored procedures, functions, and triggers. Topics include: set up, a SQL debugging example, SQL and mixed-language debugging, limitations, debugging extended stored procedures, SQL debugging components, configuring DCOM, and troubleshooting.
© 2016 Microsoft