One of the interesting new features in SQL Server 2008 is Change Data Capture. I wrote about Change Tracking in a previous blog entry. That will track the what, when and who but will not tell you ...
Technically, CDC uses the transaction log reader functional­ity, long in use for replication, to read changes in the transaction log and write those changes to relevant change tables. The change ...