THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Paul Nielsen

www.SQLServerBible.com

AutoAudit 1.10c

AutoAudit is a free SQL Server (2005, 2008) Code-Gen utility that creates Audit Trail Triggers with:

·         Created, Modified, and RowVersion (incrementing INT) columns to table

·         Creates View to reconstruct deleted rows

·         Creates UDF to reconstruct Row History

·         Schema Audit Trigger to track schema changes

·         Re-code-gens triggers when Alter Table changes the table

 

Version 1.10c Adds:

·       Createdby and ModifiedBy columns. Pass the user to the column and AutoAudit records that username instead of the Suser_Sname value – useful for apps that manage their own users and connect using a common service account.

·         Records user’s batch that caused the change event.

·         Handles various data types better.

·         Includes several small bug fixes.

 

*   CodePlex link: http://autoaudit.codeplex.com/


initial 2007 AutoAudit blog post:
http://sqlblog.com/blogs/paul_nielsen/archive/2007/01/15/codegen-to-create-fixed-audit-trail-triggers.aspx

 

Published Wednesday, March 17, 2010 10:16 PM by Paul Nielsen

Comments

 

Calvin Jones said:

1. In the section "build _RowHistory Table-Valued UDF", the EXEC (@SQL) statement is commented out.

2. Procedure pAutoAuditDrop does not drop the Views and Table-Valued Functions.

March 19, 2010 12:15 PM
 

Rudy Hinojosa said:

I've revised the original 1.03 version to work with up to 5 composite keys.  If you are interested in this, shoot me an email at rudyhinojosa2007@gmail.com

July 15, 2010 6:20 PM
New Comments to this post are disabled

About Paul Nielsen

Paul Nielsen believes SQL is the romance language of data. As such he’s a hands-on database developer, Microsoft SQL Server MVP, trainer, and author of SQL Server Bible series (Wiley). As a data architect, he developed the concepts of Smart Database Design and Nordic – an open source O/R dbms for SQL Server. He lives in Colorado Springs.

This Blog

Syndication

News

news item test
Privacy Statement