 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
gwert
Joined: 17 Mar 2011 Posts: 2 Country: United States |
|
Preventing unnecessary records with DB Audit |
|
When using data auditing in DB Audit, it appears that update records are recorded any time an UPDATE statement is issued, even if no changes occurred. Is there any way to prevent that from happening? I'm using SQL Server 2008 R2.
|
|
Thu Mar 17, 2011 2:57 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Quote: "UPDATE statement is issued, even if no changes occurred" - there is no such thing in db world. If your application executes an update statement like
UPDATE my_table SET my_column = 5 WHERE key_col = 1
and the value in my_column is 5 before update, this is a still a physically executed update with writes to the disk cascading processing, index updates, etc… and as such it is recorded in the audit trail.
Now, if you want to limit auditing to updates affecting business important columns with value changes, use Column Change filters to select columns whose changes will lead to recording in the audit trail. Please don't confuse column selection for auditing and column-change filters.
|
|
Fri Mar 18, 2011 9:57 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|