开启CDC

查询agent

exec xp_servicecontrol N'QUERYSTATE', N'SQLSERVERAGENT';

开启cdc

exec sys.sp_cdc_enable_db;

查询cdc是否开启

select name, is_cdc_enabled from sys.databases where name = 'wBird_MainDB';

开启表

exec sys.sp_cdc_enable_table  @source_schema = 'dbo', @source_name = 'wBird_Order', @role_name = null, @capture_instance = 'wBird_Order';
exec sys.sp_cdc_enable_table  @source_schema = 'dbo', @source_name = 'wBird_UserBase', @role_name = null, @capture_instance = 'wBird_UserBase';

查询表开启情况

select name, is_tracked_by_cdc from sys.tables where name = 'wBird_Order';
select name, is_tracked_by_cdc from sys.tables where is_tracked_by_cdc=1;

关闭表cdc

exec sys.sp_cdc_disable_table @source_schema = 'dbo', @source_name = 'test', @capture_instance = 'test';