66

I have a trace setup for SQL Server Profiler to monitor SQL that is executed on a database. I recently discovered that trigger execution is not included in the trace. After looking through available events for a trace, I do not see any that look like they would include trigger execution. Does anyone know how to setup a trace to monitor the execution of triggers?

Kevin Fairchild
  • 10,891
  • 6
  • 33
  • 52
firedfly
  • 2,299
  • 2
  • 22
  • 20

2 Answers2

75

Stored procedures: - SP:StmtStarting - SP:StmtCompleted

Mladen
  • 1,710
  • 12
  • 4
  • 2
    I don't think this event type is specifically for Triggers, in fact when using it in practice it seems to Start and Complete on every single line of code – Luke T O'Brien Jul 04 '17 at 13:30
  • It's not specific to triggers, but it is how to setup a trace to monitor the execution of triggers, which answers the question – BlackTigerX Jan 16 '19 at 18:08
52

In SQL Server Profiler 2008, when starting/configuring the trace, go to the "Events Selection" tab, click on the "Show all events" checkbox, and then in the list under the Stored Procedures section select the SP:StmtStarting and SP:StmtCompleted events to be included in the trace.

Lachlan Wetherall
  • 765
  • 7
  • 11