Post reply

Triggers

  • July 22, 2002 at 4:52 am

    #158125

    Is there a way to monitor when or if a trigger is fired, using a trace or through T-SQL

  • July 22, 2002 at 5:57 am

    #433158

    You can write output to another table when trigger is fired as a means to know when or you can look for in Profiler in SQL items where you can filter by DatabaseID and ObjectID or ObjectName. If this needs to be a permanent thing use the trigger write to table method, if temporary use Profiler.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply