Microsoft® SQL Server 2005 Unleashed

Chapter 25. Creating and Managing Triggers

IN THIS CHAPTER

• What’s New in Creating and Managing Triggers

• Using DML Triggers

• Using DDL Triggers

• Using CLR Triggers

• Using Nested Triggers

• Using Recursive Triggers

A trigger is a special type of stored procedure that is executed automatically based on the occurrence of a database event. In previous versions of SQL Server, the database events that fired triggers were based on data manipulations, such as insertions, updates, or deletions. Triggers in SQL Server 2005 can also fire on events that are related to the definition of database objects. The two triggering events are referred to as Data Manipulation Language (DML) and Data Definition Language (DDL) events.

Most of the benefits derived from triggers are ...