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';