A SQL trigger is a code block that executes automatically when a specified event occurs on a table or view, such as an insert, update, or delete. A trigger can be used to perform actions before or ...

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.

Es gibt zwei Haupttypen von SQL-Triggern: DML-Trigger und DDL-Trigger. DML-Trigger werden durch die Datenmanipulationssprache ausgelöst (DML) -Anweisungen wie INSERT, UPDATE oder DELETE.

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