Simple-Talk.com has published my very first article on their site. This article is introducing Change Data Capture – the new concept introduced in SQL Server 2008. 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.
Introduction to Change Data Capture (CDC) in SQL Server 2008
Please read my article and leave your valuable comments here. If you like the article do not forget to rate it.
Reference : Pinal Dave (http://blog.sqlauthority.com)
pinaldave
Nice Article and i read a similar once before but this one is so simple to understand.. really you have a art to present things in very simple way…. see u change my thinking about indexes i dropped 4 after came back to Delhi
Hello sir,
One of the best article i have ever read.
I have one question
what, you are explaining about the Mask,
that it stores in hexadecimal and after convert it into
bit you know which columns are updated.
what is the limit of that mask storing.
i have table which has 185 columns so any easy way to
find which column i have updated or
can i get the name of the columns which are updated.
one things is
if i update with same value
example column id has value – 1 and
i update it with again 1 then that
cdc records that thing ?
Hi Kuldip,
You can have any number of column here. CDC supports as much as column in tracking as much are allowed by table creation.
No, as name suggests Changed Data Capture, it will not track the column if do not change the value.
Kind Regards,
Pinal
Looks like CDC is very much scaleable compared to trigger based tracking (our good old method )
I have a system of triggers now that provides an undo/redo feature along with history commands that show a record’s history of changes. I’m wondering if CDC can be used to such functionality. Any thoughts?