Sign Up Now!Log In
steve gray 8/9/2011 7:24:59 AM

Table Auditing

Auditing SQL tables is a very basic concept. You ocassionally need to save all changes to a table so that you have some history of the changes.

This script creates an audit table and triggers for the specified table.

Run the script against any table and an audit table will be created with the same name as the source table + 'AUDIT'. So auditing 'myTable' creates 'myTableAUDIT'.

We also create insert, update, and delete scripts that will populate the table.

You'll also need this script: http://dyndeveloper.com/ArticleView.aspx?ArticleID=1707



Version: Unknown or N/A
Section: SQL Scripts