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