Home Library Learn Samples Downloads Support Community Forums
1 out of 1 rated this helpful - Rate this topic

Setting Up Transact-SQL Debugging

Visual Studio 2010

This topic applies to:

Visual Studio Ultimate

Visual Studio Premium

Visual Studio Professional

Visual Studio Express

s4sszxst.DoesApplybmp(en-us,VS.100).gifs4sszxst.DoesApplybmp(en-us,VS.100).gifs4sszxst.DoesApplybmp(en-us,VS.100).gifs4sszxst.DoesNotApplybmp(en-us,VS.100).gif

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.

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.