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.
- Debug Settings and Preparation
Covers the settings and preparation that you must perform to debug your program with the Visual Studio debugger.