SQL profiler to trace trigger events

Use Standard Default template and MUST Add SP:StmtCompleted 


Now kick off SQL Profiler and a new trace; you need only trace the SP:StmtCompleted event because that’s where trigger execution appears. 

Choose text data if you want to trace for particular tables