Editors Note:
There is a more recent version of this script here: http://dyndeveloper.com/ArticleView.aspx?ArticleID=4015
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