Setting Up Transact-SQL Debugging

This topic applies to:

Visual Studio Ultimate	Visual Studio Premium	Visual Studio Professional	Visual Studio Express

This document describes how to set up Visual Studio for debugging Transact-SQL with an instance of SQL Server 2005 or later. The procedures that are described here need be done only one time, with a few exceptions that will be described. There are additional enabling procedures that are required when you create a SQL Server project type, and every time that you create a database connection.

For more information about debugging Transact-SQL with SQL Server Management Studio, see Using the Transact-SQL Debugger.

In This Section

• How to: Enable Transact-SQL Debugging
  Provides high-level instructions for enabling Transact-SQL debugging.

• Transact-SQL Debugging Setup Errors and Troubleshooting
  Lists issues you may encounter when you set up Transact-SQL debugging and solutions to those problems.

• Remote T-SQL Debugging on Windows Vista
  Explains some Windows Firewall configuration steps that occur the first time that you begin remote Transact-SQL debugging.

Related Sections

• Debug Settings and Preparation
  Covers the settings and preparation that you must perform to debug your program with the Visual Studio debugger.

See Also

Other Resources

Debugger Security