The trigger is working and capturing the sql code that makes the change. Thank you all. I used a table that I truncate at the beginning of each trigger run instead...

The bug is in the application code (not a store proc) and is making bad updates to a table. I need to id the bad code and want a trigger...

I am filling in as a temp for a DBA who left a few weeks ago until they can hire another under paid direct hire. Today when users cried that...

I have used Spotlight but it's only good for looking into the problem while it exists and use the wrong tool for see what happened.  I was able to use...

I had success with using some of the tools from Quest, Idrea & MOM at a previous client location. I liked Quest Performance Anaylsis the best. It allowed me to see...