Export (0) Print
Expand All

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

Community Additions

ADD
Show:
© 2014 Microsoft