Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

Designing DML Triggers

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?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.