Export (0) Print
Expand All

SQL Debugging Software Requirements

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 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.

Database Tier Software Requirements

SQL debugging with Microsoft Visual Studio 2005 requires the following software on the server:

  • Microsoft Windows 2000 or later is recommended.

  • SQL Server 2005 or SQL Server 2000 with Service Pack 3 required.

Database Tier Software Requirements (SQL CLR only)

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\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.

Additional Multi-tier Software Requirements

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:

  • SQL Client

  • 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.

Development Environment

For information on Visual Studio 2005 's system requirements please see Visual Studio Hardware Requirements.

SQL debugging with Microsoft SQL Server 2005 requires one of the following Visual Studio 2005 editions:

  • Visual Studio 2005 Pro

  • Visual Studio Tools for Office

  • Visual Studio 2005 Team Edition for Architects

  • Visual Studio 2005 Team Edition for Developers

  • Visual Studio 2005 Team Edition for Testers

  • Visual Studio 2005 Team Suite

See Also

Community Additions

ADD
Show:
© 2014 Microsoft