Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Debugging Database Objects That Use Managed Code (SQL CLR Debugging)

[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]

This topic applies to:

Edition

Visual Basic

C#

C++

Web Developer

Express

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

Standard

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

Pro and Team

Topic applies Topic applies Topic applies Topic applies

Table legend:

Topic applies

Applies

Topic does not apply

Does not apply

Topic applies but command hidden by default

Command or commands hidden by default.

This section contains samples for all CLR SQL database object types.

There are three different scenarios to consider:

In order to debug a trigger, you must start your debugging session in a stored procedure. In particular, you cannot debug a stand-alone SQL script, nor can you debug a trigger by causing it to fire by invoking a script.

How to: Debug a SQL CLR Stored Procedure

Demonstrates how to debug stored procedures on a SQL Server. Information includes connecting to a database, creating a stored procedure, stepping into a stored procedure, setting breakpoints, viewing parameters and local variables in the Locals window, and dragging variables from the Text editor into the Watch window.

Walkthrough: Debugging a SQL CLR Trigger

Demonstrates how to step from a stored procedure into a trigger when it fires.

Walkthrough: Debugging a SQL CLR User-Defined Scalar Function

Demonstrates how to step into a User Defined Function.

Walkthrough: Debug a SQL CLR User-Defined Table-Valued Function

Demonstrates how to step into a User Defined Table-Valued Function.

Walkthrough: Debugging a SQL CLR User-Defined Aggregate

Demonstrates how to step into a User Defined Aggregate.

Walkthrough: Debugging a SQL CLR User-Defined Type

Demonstrates how to step into a User Defined Type.

Show:
© 2014 Microsoft. All rights reserved.