Microsoft SQL Server 2012 Bible

Removing Change Data Capture

Removing change data capture is a flexible and simple process, should you decide it isn't working or necessary. CDC can be disabled table by table, or for the whole database. When CDC is disabled for the database, it automatically disables all tables, removing the SQL Agent jobs, and dropping the custom tracked table functions. There's no need to remove CDC from each table individually before disabling CDC from the database:

EXEC sys.sp_cdc_disable_db;

To remove CDC from a specific table, use the following system stored procedure:

EXEC sys.sp_cdc_disable_table
 @source_schema = ‘HumanResources',
 @source_name = ‘Department',
 @capture_instance = ‘all';