Introduction to DML Triggers

This article by Jack Corbett explains what triggers are, the different types, and how to avoid common mistakes.

Disabling a Trigger for a Specific SQL Statement or Session

I want to suppress the trigger from firing for a particular statement while it remains in its normal execution state for any of the other statements. Is there any way this can be done dynamically?

Comparing SQL Server constraints and DML triggers

Over the years, I have witnessed many developers being confused about when to use data-manipulation language (DML) triggers vs. when to use constraints.

Using Triggers for Detective Work

When a value is changed that causes an error, finding what caused the error can be tricky. Here an application was truncating a column. The trigger helped to identify the culprit.

DML Trigger Status Alerts

When databases suddenly stop working, it can be for a number of different reasons. Human error plays a large part, of course, and the DBA needs to know what these various humans are up to. DDL triggers can help alert the DBA to unauthorized tampering with a production system, of course, but DDL triggers can't tell you everything. At some point, you will need to implement your own checks. Randy certainly reached that point!

Script Generates Audit Triggers

This script generates a audit trigger for each table in the database. The trigger then logs when each table is updated.

Set trigger firing order

DML Triggers

Checking a Trigger

DDL Triggers in SQL Server 2005

DDL Triggers are key improvement in SQL Server auditing, allowing tracking of events such as the creation of a new table, database or user.