SQL SERVER – Download Script of Change Data Capture (CDC)

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)

11 thoughts on “SQL SERVER – Download Script of Change Data Capture (CDC)

  1. Pingback: SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 2 Journey to SQL Authority with Pinal Dave

  2. 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?


  3. Pingback: SQL SERVER – A Quick Look at Logging and Ideas around Logging « SQL Server Journey with SQL Authority

  4. Hi Pinal,

    I want to Capture who altered data in the CDC table.
    Im able to get windows AD level users, but i cant get it from database table level users


  5. Hi Pinal,

    I want to Capture users in CDC table,
    I have users table with 5 users and application using 1 ID to connect to the database.

    How can i add a column to capture users logins.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s