|
SQL Server 2008 functionality for Audit Log
Posted: 18 Nov 2009 07:10 AM |
Hello
I have to implement a functionality for audit ( insert/update/delete ) log of the each table.
There are two option
1) Through SQL Server 2008 Feature : I heard that in the SQL Server 2008 we have CDC(Change Data Capture) features which can be enable on each table and track each data changes. It insert new row into a special system table which we need audit log.
2) Create a unnormalized table for each table and handle the audit (insert/update/delete) log using the trigger.
Can anybody help to me to choose which options is best and easy to manage in the future?
Thanks,
Craig
www.totaltechresource.com
|
|
|
 |
|