How to Disable CDC( Change Data Capture) for tables or Database

Hi,

Change Data Capture (cdc) property is disabled as default. Previously i have stated how to enable the CDC for the both table and Database level and Check whether the table or Database already enabled CDC, here I will Query you how to Disable CDC for the already enabled table or Database.

Disable CDC at Database Level	Disable CDC at Table Level
USE YourDataBase; GO EXECUTE sys.sp_cdc_disable_db; GO	USE YourDataBase; GO EXECUTE sys.sp_cdc_disable_table     @source_schema = 'dbo',     @source_name = N'TableName',     @capture_instance = N'dbo_tableName';