monitoring trigger by Profiler

Last Post 06 Oct 2005 12:50 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

03 Oct 2005 04:50 PM
Hi guys, i am trying to check what exact statement is executing when the trigger on the table is running but not able to.

The EVENT i select was TSQL: SQLStmtCompleted

What else should i select to monitor the trigger?

New Member
New Member

06 Oct 2005 12:50 AM
This is difficult to do on a busy production system.

Kalman Toth, SQL Guru
SQL Server 2005 Training

Acceptable Use Policy