Export (0) Print
Expand All

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.

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.

© 2015 Microsoft