Woohoo! I figured out a way. Create a stored procedure to trigger the (insert, delete, update) trigger. Next, debug the stored procedure in the SQL Query Analyzer and as the insert/delete/update is triggered, the debugger will step into the trigger and you can debug it like any other stored procedure.