SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Chapter Essentials

Triggers Defined Triggers are stored procedures that are launched based on events. Triggers can be DML or DDL driven. Both INSTEAD OF and AFTER triggers are available for DML triggers, but DDL triggers can only work as AFTER triggers. However, ROLLBACK can be used to undo changes even though DDL triggers are AFTER triggers.

Using Triggers Triggers can be used as automation assistants. They can be used to prevent accidental data destruction or loss. Triggers can be used by both developers and DBAs for sometimes different purposes and sometimes shared purposes.

Creating Triggers Triggers are created with the CREATE TRIGGER statement. Triggers can be created at three levels. The first level is the server level, and these are mostly ...