We know about triggers as they exist in SQL Server 2000 and its previous versions ? triggers that fire in response to INSERT, UPDATE and DELETE events.

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 ...

For our app, we have a service that will update a VersionId column for a given record (SQL Server 2008), which is hooked up to the following trigger to populate some tables that hold historical ...