SQL CLR Database Debugging
This topic applies to:
Pro and Team
Does not apply
Command or commands hidden by default.
This section contains samples for all CLR SQL database object types.
There are three different scenarios to consider:
Stepping into a SQL Server 2005 database object using Server Explorer. For more information, see How to: Step into an Object Using Server Explorer.
Running a test script using a Visual Studio 2005 SQL Server project.
Running an application that calls a stored procedure. For more information, see How to: Debug a SQL CLR Stored Procedure.
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.