I am trying to trace what a 3rd party trigger is doing in the database. I can see from the code that is uses temporary tables and updates these using a cursor, which I suspect is making them run slowly. In Profiler I am monitoring all events for TSQL and StoredProcedures but I do not see any SQL from the triggers. Has anyone had any success trying to monitor triggers? Cheers.
I'm able to capture them with the SP<img src='/community/emoticons/emotion-7.gif' alt=':S' />tmtCompleted event.<br /><br />The TextData is formatted as follows:<br /><br />-- Trigger Name<br />(Followed by the SQL Code of the Trigger)<br /><br />Find the names of the triggers and look them up in your Profiler trace.<br />