AutoAudit – Source and Documentation Archive

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 […]

How to use existing date/time and user/created, user/modified columns names with AutoAudit

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 […]