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.

Like all good problems, this one is sporadic and seemingly senseless, but I figured maybe somebody here would have some suggestions on possible causes of the situation to be laid out. For our app ...