Example of Change Data Capture in sql server 2008 1

Lets understand this feature with help of some examples, here we will create test database with dummy table and data to perform DML operation like INSERT, UPDATE and DELETE. create database TestDb use testdb create table st_trackingdata (st_name varchar(10), Grade char(1) ) Lets add one dummy data in table with out enabling CDC (Change data capture) feature for database. insert into st_trackingdata values(‘sandeep’,’B’) If you are ...