How to get SQL Profiler to track trigger trigger

Question

I have a trace setup for SQL Server Profiler to monitor SQL that is running in a database. I recently discovered that trigger triggering is not included in the trace. Having looked at the available events for tracing, I do not see those that would include trigger execution. Does anyone know how to configure tracing to track trigger execution?

Answer 1

Stored Procedures: - SP: StmtStarting - SP: StmtCompleted

Answer 2

In SQL Server Profiler 2008, when you start / configure tracing, go to the "Select events" tab, select the "Show all events" check box, and then select SP: StmtStarting and SP: StmtCompleted events to be enabled in the list in the "Saved procedures" section into the trace.