Debugging Preparation: SQL Server Projects

This topic applies to:

Edition

Visual Basic

C#

F#

C++

Web Developer

Express

Topic applies Topic applies Topic applies Topic does not apply Topic does not apply

Pro, Premium, and Ultimate

Topic applies

Topic applies

Topic applies

Topic does not apply

Topic does not apply

The SQL Server project template creates the default project settings for debugging. When you choose Start from the Debug menu, these settings cause Visual Studio to begin SQL debugging.

To debug a SQL Server Project

  1. Open the project in Visual Studio.

  2. In Solution Explorer, right-click the project name and choose Properties.

  3. In the Project Properties dialog box, open the Configuration Properties node and select Debugging.

  4. In the grid control, set Enable SQLCLR debugging.

  5. Click OK to close the Project Properties dialog box.

  6. On the Debug menu, choose Start.

  7. Debug using the techniques described in Debugging SQL Database Objects.

See Also

Other Resources

Debugging SQL

Setting Up SQL Debugging

How to: Enable Multi-tier Debugging

How to: Enable CLR Debugging For a Connection

Setting Up SQL Debugging

Walkthrough: CLR SQL Database Debugging

Debugging SQL Database Objects