Export (0) Print
Expand All
2 out of 2 rated this helpful - Rate this topic

SQL CLR Database 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

Yes

Yes

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.

In This Section

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.

See Also

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.