-
I need to log historical changes to personal details in a table but don't really care about insertions or deletions.
I notice that the default trigger includes in it's update section something like:
INSERT INTO [tablename_Audit]
([field1],[field2],[field3])
VALUES
(@FIELD1, @FIELD2, @FIELD3)
This logs the current value the data was changed to but I would prefer a...
2009-10-01 17:24:28 UTC by evil666overlord
-
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...
2008-10-27 16:00:07 UTC by aferende
-
aferende committed patchset 14 of module SqlAudit to the SQL Audit CVS repository, changing 11 files.
2008-10-27 08:49:15 UTC by aferende
-
aferende committed patchset 13 of module SqlAudit to the SQL Audit CVS repository, changing 3 files.
2008-01-17 16:23:04 UTC by aferende
-
aferende committed patchset 12 of module SqlAudit to the SQL Audit CVS repository, changing 5 files.
2008-01-17 16:15:20 UTC by aferende
-
Bug fixed in the 2.0.0.0 release.
Thx for your collaboration.
Regards,
Andrea.
2008-01-17 15:59:17 UTC by aferende
-
Will be fixed asap.
Regards,
Andrea.
2008-01-14 21:34:22 UTC by aferende
-
Hello, Andrea!
I receive the following error message when executing the generated audit script. Perhaps you can check the xml data type handling in your future releases? Thanks in advance.
Micha
Server: (local), Msg: The xml data type cannot be compared or sorted, except when using the IS NULL operator., Level: 16, State: 1, Line: 497
The xml data type cannot be compared or sorted...
2008-01-12 12:21:09 UTC by nobody
-
aferende committed patchset 11 of module SqlAudit to the SQL Audit CVS repository, changing 12 files.
2007-12-06 22:37:27 UTC by aferende
-
aferende committed patchset 10 of module SqlAudit to the SQL Audit CVS repository, changing 8 files.
2007-07-20 21:18:51 UTC by aferende
