时间:2021-07-01 10:21:17 帮助过:33人阅读
USE AdventureWorks ; GO EXECUTE sys . sp_cdc_enable_table @source_schema = N'Person' , @source_name = N'ADDRESS' , @role_name = N'cdc_Admin' -- 可以自动创建 , @capture_instance = DEFAULT GO EXECUTE sys . sp_cdc_enable_table @source_schema
USE AdventureWorks;
GO
EXECUTE sys.sp_cdc_enable_table
@source_schema = N'Person'
, @source_name = N'ADDRESS'
, @role_name = N'cdc_Admin'--可以自动创建
, @capture_instance=DEFAULT
GO
EXECUTE sys.sp_cdc_enable_table
@source_schema = N'Person'
, @source_name = N'Contact'
, @role_name = N'cdc_Admin'--可以自动创建
, @capture_instance=DEFAULT
GO