SQLServerCentral.com Scripts tagged Triggers

DDL Triggers Implementation

Thu, 02 Oct 2008 14:05:16 UT

How to use DDL triggers and Query the Data with minimum performance impact.

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

Using Triggers for Detective Work

Thu, 25 Sep 2008 06:00:00 UT

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.

Script Generates Audit Triggers

Wed, 23 Nov 2011 07:00:00 UT

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

Table journal

Wed, 12 Dec 2007 07:00:00 UT

Create journal to audit changes in user table

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.