SQL Server Performance Forum – Threads Archive
How to trace a table triggerI’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.
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