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.

Using DDL Triggers in SQL Server 2005 to Capture Schema Changes

This article shows how to use DDL triggers to capture schema changes. This solutions works a little differently than most DDL triggers examples. This script captures the old object that was replaced.

Row-By-Row Processing Without Cursor

If you are a SQL Server DBA, you realize that the performance of cursors is not great and they should be avoided where possible. One place it is difficult to avoid cursors is individual row processing within a trigger. Amin Sobati brings us a new article that shows just how you can avoid this.

Using DDL Database Triggers

In this short demonstration, you'll learn how to use DDL database triggers to prevent changes to product and audit changes to comply with Sarbanes-Oxley and other change management requirements. Free registration required.

Triggers for Auditing

Have you ever needed to audit your SQL Server 2000 database for changes to a table? A simple auditing solution is presented here by new author Tiago Silva using an INSTEAD OF trigger.