|Important||This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer|
SQL Debugging Software Requirements
This topic applies to:
Pro and Team
Does not apply
Command or commands hidden by default.
This section describes the software required for debugging the code in a SQL Server database. There are additional requirements when debugging a SQL Server multi-tier application. For more information, see Multi-tier Application Database Debugging.
SQL CLR debugging requires the following additional software on the server:
The Remote Debugging Monitor (msvsmon) is required to be running when you debug. If you are running SQL Server 2005 , the setup program to install msvsmon is already on the server, in <sql server install dir>\ 90\Shared\1033\rdbgsetup.exe. Run this program to install it, and SQL Server will launch it whenever you step into or hit a breakpoint.
All other requirements on this page apply to SQL CLR as well as TSQL.
With Visual Studio 2005, you can debug multi-tier applications that make connections to SQL Server databases and execute SQL stored procedures. To do this, the application tier must connect to the databases using one of the following:
OLE DB, ODBC, or DBLIB.
A technology such as ADO or ADO.NET that is built on top of OLE DB or ODBC.
The managed data adapter for SQL Server.