This documentation is archived and is not being maintained.

Debugging SQL

This topic applies to:


Visual Basic



Web Developer


Topic does not applyTopic does not applyTopic does not applyTopic does not apply


Topic does not applyTopic does not applyTopic does not applyTopic does not apply

Pro and Team

Topic appliesTopic appliesTopic appliesTopic applies

Table legend:

Topic applies


Topic does not apply

Does not apply

Topic applies but command hidden by default

Command or commands hidden by default.

With the Visual Studio 2005 debugger, you can now debug managed common language runtime (CLR) assemblies running inside the SQL Server 2005 process in much the same way that you have debugged stored procedures, functions, triggers, and other kinds of database objects.

For more information, see What's New in the Visual Studio Debugger.

SQL Debugging Limitations

Describes restrictions and limitations on the use of SQL Debugging features.

Setting Up SQL Debugging

Lists software requirements for SQL debugging, for the server and workstation, instructions for enabling SQL debugging, installing, configuring, and troubleshooting setup.

Debugging SQL Database Objects

Provides detailed instructions and samples for each type of SQL Server database object that can be debugged.

Multi-tier Application Database Debugging

Describes how to debug applications whose components are located on multiple machines.

Overview of Visual Database Tools

Describes and provides links to topics on Microsoft Visual Database Tools and database connections and references.

Creating SQL Server 2005 Objects in Managed Code

Describes how to create CLR SQL database objects in Visual Studio using the SQL Server project type.