AutoAudit was originally published on CodePlex. That site is now archived, but we never know for how long it will last. I want to preserve the code and documentation here. This is the source of something I blogged about in 2015, AutoAudit – sql audit trail tool AutoAudit.zip – Archive of Original Code from CodePlex […]
AutoAudit by default will add 5 columns to your table, when you turn it on for a table with this command: EXEC [Audit].[pAutoAudit] @TableName='SEOConfig', @BaseTableDDL=1; Those columns are: AutoAudit_CreatedDate, AutoAudit_CreatedBy, AutoAudit_ModifiedDate, AutoAudit_ModifiedBy, and AutoAudit_RowVersion. However, you often have your own columns for the first four: CreatedDate, CreatedBy, ModifiedDate, and ModifiedBy, and you can tell AutoAudit […]
CodePlex is long gone, but the script can now be found here: https://github.com/koenmd/AutoAudit/blob/master/README.md A few years ago I discovered a great utility called “Auto Audit” on CodePlex by Paul Nielson (author of “Sql Bible”) and John Sigouin. The best thing is that it creates triggers that audit insert, update, and deletes on any desired table. […]