My article written on subject of Introduction to Change Data Capture (CDC) in SQL Server 2008 is quite a popular and I have received many request for uploading the script associated with this subject.
Change Data Capture records INSERTs, UPDATEs, and DELETEs applied to SQL Server tables, and makes a record available of what changed, where, and when, in simple relational ‘change tables’ rather than in an esoteric chopped salad of XML. These change tables contain columns that reflect the column structure of the source table you have chosen to track, along with the metadata needed to understand the changes that have been made. Pinal Dave explains all, with plenty of examples in a simple introduction.
Click to Download Scripts
Please leave your comments here if you have liked above article and script.
Reference : Pinal Dave (http://blog.sqlauthority.com)
Fundoo and must read Article..
Thanks for Sharing this script,
This is very useful feature.
Thank you very much. It is very useful. I need it.
Pingback: SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 2 Journey to SQL Authority with Pinal Dave
This was a great article… I am looking for any inputs on what CDC does the performance. Also, how do we go about cleaning up the Sys tables – do we need to use the same archive/purge strategy like the live tables?
Pinal I can’t get it
actually i can’t download any of ur downloads… :(
plz help me
Pingback: SQL SERVER – A Quick Look at Logging and Ideas around Logging « SQL Server Journey with SQL Authority