Saturday, February 25, 2012

Debugging Triggers

I was wondering if it is possible to pop up a dialog box from a SQL trigger.

This would be a great way to debug triggers as you could report variable values in the dialog box.

If not, does anybody have any suggestions as to the best way of reporting out variable values whilst a trigger is running?Sometimes I will feed values and sql strings into a table, sometimes I will use profiler with all of the XXXcompleted events turned on for th Transact-SQL and stored prpcedures classes.|||Install the stored procedure debugging package from the MS-SQL CD? I haven't used it in a while, but it lets you set breakpoints, watches, etc. very much like Visual Studio.

-PatP

No comments:

Post a Comment