Tag: sp_cdc_enable_table

CDC does not require Unique Index

Chris Skorlinski [MSFT] Try This May 25, 2010

Change Data Capture feature of SQL 2008 is based on Transactional Replication. CDC and Transactional Replication used the same internal stored procedure sp_replcmds to retrieve data updates from the transaction log. However, unlike Transactional Replication, CDC does NOT require the tables to have a unique index (or Primary Key). In fact CDC can be use
Read More »

References and Links on Change Data Capture

Chris Skorlinski [MSFT] Best Practices April 19, 2010

I’m developing in-depth training on Change Data Capture and created this BLOG posting as a reference for BOL topics and Web links I found helpful while researching CDC. I’ll update this posting with more links as time goes by. I hope you too find these helpful. Basics of Change Data Capture (great chart and overview
Read More »