How to trace a table trigger | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to trace a table trigger

I’ve been seeing instances where a trigger on a table either does not fire, or it does not do the necessary update. I had a quick look around in profiler, and I have not found the right events, classes and data colums to do this. Any suggestions? Thanks so much, it’s been a while since I’ve had to trace something – and it was never a trigger. Karen SQLGoddess
Life is one fool thing after another whereas love is two fool things after each other.— Oscar Wilde
May be: sp_trace_generateevent
can help, see BOL for details.
Luis Martin
Moderator
SQL-Server-Performance.com
Thanks, Luis, I will look at that. Karen
Found it…SP<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />tmtStarting captures the trigger being fired..<br />Thanks<br /><br /><br />Token SQL Goddess <br />Life is one fool thing after another whereas love is two fool things after each other.— Oscar Wilde
]]>