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