Switch View :

Lightweight Beta

Visual Studio Debugger

Setting Up SQL Debugging

This topic applies to:

Visual Studio Edition	Visual Basic	C#	C++	J#	Visual Web Developer
Express	No	No	No	No	No
Standard	No	No	No	No	No
Pro/Team	Yes	Yes	Yes	No	No

This section describes how to set up SQL debugging. The procedures described here are one-time, with a few exceptions to be described. There are additional enabling procedures required when you create a Visual Studio 2005 SQL Server project type, and each time you create a database connection. For further information, see: How to: Enable SQL Server 2005 Debugging, How to: Enable SQL Debugging For a Project, and How to: Enable CLR Debugging For a Connection.

In This Section

SQL Debugging Software Requirements: Lists the software requirements for SQL debugging.

Enabling SQL Debugging: Provides high-level instructions for enabling SQL debugging. This includes, running Remote Components Setup, which will install SQL debugging components on the server, and setting up SQL Server permissions for debugging.

Setting SQL Server Permissions for Debugging: Provides instructions on giving debugging access to SQL Server users.

Installing a New Version of SQL Server After Enabling SQL Debugging: Recommends that you set up remote debugging again if you have installed a new version of SQL Server after enabling SQL debugging.

SQL Debugging Setup Errors and Troubleshooting: Lists issues you may encounter when setting up SQL debugging and solutions to those problems.

Related Sections

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

Debugging SQL: Provides information on debugging SQL Server stored procedures, functions, and triggers.

See Also

Concepts

Debugger Security

Tags :