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.
Download Script of Change Data Capture (CDC)
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.
[...] lunch we had wonderful event called Features of Birds MVP Lunch. During this event, I talked about Change Data Capture (CDC). I was very fortunate that many people showed up at my table. I really hoped that I could have [...]
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
[...] Download Script of Change Data Capture (CDC) [...]