Export (0) Print
Expand All

Designing DML Triggers

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



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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft