DML Triggers

A DML trigger is an action programmed to execute when a data manipulation language (DML) event occurs in the database server. DML events include UPDATE, INSERT, or DELETE statements issued against a table or view. DML triggers are used to enforce business rules when data is modified and to extend the integrity checking logic of Microsoft SQL Server 2005 constraints, defaults, and rules.

This section provides the information necessary to understand, design, and implement DML triggers.

Topic	Description
Understanding DML Triggers	Explains DML trigger concepts and includes descriptions and examples of when to implement DML triggers.
Designing DML Triggers	Provides specific guidelines, rules, and restrictions you should consider when designing a DML trigger.
Implementing DML Triggers	Describes the procedures to create, modify, or delete a DML trigger.