Enabling 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

Enabling SQL Debugging

If you have the required software, you can enable SQL debugging by performing these steps. For more information, see Software Requirements.

To enable SQL debugging

  1. Run Remote Components Setup, which will install SQL debugging components on the server. For more information, see Setting Up Remote Debugging and Remote Components Setup.
  2. Set Up SQL Server permissions for debugging. For more information, see Setting SQL Server Permissions for Debugging.
  3. Configure DCOM for SQL debugging on the server for SQL debugging. For more information, see Configuring DCOM for SQL Debugging.

See Also

Setting Up SQL Debugging | Debug Settings and Preparation | Debugging SQL | Troubleshooting SQL Debugging Setup | Enabling SQL Debugging on SQL 2000 Desktop Engines

© 2016 Microsoft