T-SQL Script Generator for SQL Server 2000/2005 to Allow Auditing on Database Tables using Triggers and Additional tables for Auditing. SQL Audit is made up of two .NET 2.0 Assemblies: SqlAudit.dll and SqlAuditGenerator.exe.
2.0.1.0 – October 26, 2008
- Bug fix: When FireUpdateTriggerForDifferentValuesOnly is set to true, the current script is not handling NULL values.
Added SET ANSI_NULLS OFF to the trigger creation script.
(Thanks to Richard Tang: http://sourceforge.net/forum/forum.php?thread_id=2189296&forum_id=666866\)
Build History - 2.0.0.0 – January 17, 2007
------------------------------------------
- Bug fix to support Xml data type comparison (inside triggers).
(Thanks to Micha: https://sourceforge.net/tracker/? func=detail&atid=930265&aid=1869907&group_id=189671)
Build History - 1.9.5.0 – December 6, 2007
------------------------------------------
- Added UseTableId property into the Audit Settings to allow OBJECT_ID objects identification. Default value is true.
(Thanks to Richard Tang: http://sourceforge.net/forum/forum.php?thread_id=1775080&forum_id=666866\).
Build History - 1.0.0.0 – July 20, 2007
---------------------------------------
- Change on Main Transaction_Audit table. Audit_[TableName] and Audit_[AuditTableName] are now an hard-copy (not computed) of table name and audit table name. Table name is used instead of OBJECT_ID(‘Table Name’) in the Audit Views.
(Thanks to Richard Tang: https://sourceforge.net/forum/message.php?msg_id=4406156\).
- Bug Fix on Custom Columns generation inside Triggers.
(Thanks to Richard Tang: https://sourceforge.net/forum/message.php?msg_id=4229075\).
- Bug Fix on ExcludedColumns property (timestamp, text, ntext, image still in ExcludedColumns list).
(Thanks to Richard Tang: https://sourceforge.net/forum/message.php?msg_id=4215440\).
- Assemblies Sign: SqlAudit.dll and SqlAuditGenerator.exe are now signed with a new key (pfx file). Pfx files are now password protected.
Build History - 1.8.0.0 – March 18, 2007
----------------------------------------
- Change in update trigger section. Only updated columns will be written into the Audit Tables, all other has NULL value.
- Added string GetEnclosedFullTableName() method that return the full entity name (i.e. [dbo].[Employees]).
- Added t-sql comment at the top of the script with SQLAudit version info.
- Added TableScriptGeneratedHandler(TableInfo tableInfo, ref string generatedScript) delegate.
- Added TableScriptGeneratedHandler TableScriptGenerated event raised after each table script generation.
This event can be used to customize each generated script (generatedScript parameter).
- Added AuditUpdatedColumnsOnly property (Write into Audit table changed columns only or all columns ?).
- Added FireUpdateTriggerForDifferentValuesOnly property (Fire Update trigger for different values only or always ?).
(Thanks to Richard Tang: http://sourceforge.net/forum/forum.php?thread_id=1694394&forum_id=666866 ).
Build History
-------------
1.7.0.0 – March 18, 2007
- Change in update trigger section. Only updated columns will be written into the Audit Tables, all other has NULL value.
- Added string GetEnclosedFullTableName() method that return the full entity name (i.e. [dbo].[Employees]).
- Added t-sql comment at the top of the script with SQLAudit version info.
- Added TableScriptGeneratedHandler(TableInfo tableInfo, ref string generatedScript) delegate.
- Added TableScriptGeneratedHandler TableScriptGenerated event raised after each table script generation.
This event can be used to customize each generated script (generatedScript parameter).
- Added AuditUpdatedColumnsOnly property (Write into Audit table changed columns only or all columns ?).
- Added FireUpdateTriggerForDifferentValuesOnly property (Fire Update trigger for different values only or always ?).
(Thanks to Richard Tang: http://sourceforge.net/forum/forum.php?thread_id=1694394&forum_id=666866 ).
Build History
-------------
1.6.0.0 – March 14, 2007
- Bug Fix SqlAudit Project serialization (ColumnSize, NumericPrecision and NumericScale are now de-serialized).
(Thanks to Richard Tang).
Build History
-------------
1.5.0.0 – March 08, 2007
- Bug Fix on Audit Triggers.
(Thanks to Richard Tang).
- Changes: Blob Fields Auditing is no more supported by SQLAudit.
Build History
-------------
1.2.0.0 – March 06, 2007
- Bug Fix on Audit Triggers to support auditing on Tables without Primary Keys.
- Added SQL Audit sample script for Northwind DB into the documentation.
- Added SQL Audit C#/VB.NET source samples.
- Minor Bug fixing on SQL Audit Generator UI.
Build History
-------------
1.1.0.0 – March 1, 2007
- Introduced Transactions_Audit Table to store the History of all Transaction on every Audit Table.
- Now all Audit default columns (UserSID, HostName, ApplicationName, AuditDateTime, etc…) are deployed into Transactions_Audit table instead of each Audit Table.
- Introduced [“TableName”_Audit_View] view for each table to see the history of all operations.
- Added TransactionAuditTableName (string) property to store Transaction Main Audit table name (Default: “Transaction_Audit”).
Build History
-------------
1.0.0.1 – February 28, 2007
- Bug Fix on AuditUpdatedBitmask Audit column (wrong data type size).
Build History - 1.0.0.0 - February 27, 2007
-------------------------------------------
- First Release.