Friday, 21 July 2023

Disable CDC at table level

 How to Disable CDC( Change Data Capture) for tables

Change Data Capture (cdc) property is disabled as default.  here I will Query you how to Disable CDC for the already enabled table .

USE YourDataBase;

GO

EXECUTE sys.sp_cdc_disable_table

    @source_schema = 'dbo',

    @source_name = N'TableName',

    @capture_instance = N'dbo_tableName';

No comments:

Post a Comment

Disable CDC at table level

 How to Disable CDC( Change Data Capture) for tables Change Data Capture (cdc) property is disabled as default.  here I will Query you how t...