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.