Figure 6. Debug a .NET Database Trigger
You use the VS.NET 2005 IDE to attach to the SQL Server 2005 database process (SQLSERVR.exe). Once it's attached, a breakpoint is set within the .NET code for the database trigger. Then you force the trigger to fire by performing an INSERT on the dbo.Test_Table table within the SQLQuery window.