Microsoft® SQL Server 2008 R2 Unleashed

Chapter 30. 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 executed automatically based on the occurrence of a database event. Prior to SQL Server 2005, the database events that fired triggers were based only on data manipulations, such as insertions, updates, or deletions. Triggers in SQL Server 2005 and SQL Server 2008 can also fire on events related to the definition of database objects. The two types of triggering events are referred to as Data Manipulation Language (DML) and Data Definition Language (DDL) events.

Most of the benefits ...