CodePlex Home
Register | Sign In | CodePlex Home
AutoAudit script
Paul Nielsen
www.sqlserverbible.com

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

  • Created, Modified, and RowVerwsion (incrementing INT) columns to table
  • view to reconstruct deleted rows
  • UDF to reconstruct Row History
  • Schema Audit Trigger to track schema changes
  • Re-code-gens triggers when Alter Table changes the table

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

ScreenCast demo at: http://www.screencast.com/t/kxnHkX9LN6Q
Last edited Oct 14 2008 at 12:16 AM by PaulNielsenSQL, version 7

 

Want to leave feedback?
Please use Discussions or Reviews instead.

Updating...
© 2006-2009 Microsoft | About CodePlex | Privacy Statement | Terms of Use | Code of Conduct | Version 2009.6.1.15196