AUDIT WITH A TWIST

First the SP_TABLECOMPARE was used from the site and all credit must go to the author (greate script). This script is for the creation of an audit trial. It is generic and can be used on any sql database. It deals with legasy naming conventions as well. The script creates the audit tables and triggers. One requirement was to check for fields in the table and alter the audit table accordingly. The audit tables are exact copies of the source table. Use the script, alter, break, fix, what ever blows your hair back. Do with the script what ever you want just vote, please. Greate site. I hope this can help someone. Cheers