This topic has not yet been rated - Rate this topic

Designing DML Triggers

SQL Server 2008 R2

This section explains the factors to consider when designing a DML trigger.

Topic	Description
DML Trigger Planning Guidelines	Explains the different ways AFTER triggers and INSTEAD OF triggers can be designed.
Specifying When a DML Trigger Fires	Provides examples to illustrate the differences in firing behavior between AFTER and INSTEAD OF triggers.
DML Trigger Execution	Explains how AFTER and INSTEAD OF triggers execute once they fire.
Designing INSTEAD OF Triggers	Explains design guidelines unique to INSTEAD OF triggers.
Managing Trigger Security	Explains how trigger code can run under escalated privileges and how to mitigate this threat.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions