Most of the time, it could save the changes with maybe 2-3 UPDATE statements, and that's it.<BR><BR>So, like the title says, I want to find out what SQL statement caused a trigger to fire. have ...

The move from Microsoft SQL Server 2000 to 2005 was a big leap with many new functionalities and features introduced. The concept of DDL Triggers was one such new feature.

I am having a lot of trouble figuring out the right way to get a trigger to work and was hoping to get some suggestions. I have spent more time than I care to admit on trying to figure this out. I ...