Enable and Disabled a SQL Server Table for CDC

USE Test
GO
EXEC sys.sp_cdc_enable_table
@source_schema = N’dbo’,
@source_name = N’Sales_Test’,
@role_name = NULL,
@supports_net_changes = 1
GO

EXEC sys.sp_cdc_disable_table
@source_schema=’dbo’
,@source_name=’Sales_Test’
, @capture_instance=’dbo_Sales_Test’

Leave a Reply

Your email address will not be published. Required fields are marked *