SQL Server 2008 functionality for Audit Log
18/11/2009 7:10:53 AM
(Total replies: 0)
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.