Walk through of Microsoft SQL Server Change Data Capture

Share this Post

This sample script walks through some of the Microsoft Change Data Captures functions.  Copy and past the script into SQL Server Management Studio and execute each command.  Sample output is included in the script. This demo is based on the [AdventureWorksLT2008] database


Share this Post

4 thoughts on “Walk through of Microsoft SQL Server Change Data Capture”

  1. What are the steps to turn off cdc on a database.Would the below suffice?

    exec sys.sp_cdc_disable_db


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.