USE topicdb
GO
EXEC sys.sp_cdc_enable_db
GO




SELECT  is_cdc_enabled ,
        CASE WHEN is_cdc_enabled = 0 THEN 'CDC功能禁用'
             ELSE 'CDC功能启用'
        END 描述
FROM    sys.databases
WHERE   NAME = 'topicdb'


USE topicdb;
GO
EXECUTE sys.sp_cdc_enable_table
    @source_schema = N'dbo'
  , @source_name = N'eco_data_china'
  , @role_name = N'cdc_Admin'--可以自动创建
  , @capture_instance=DEFAULT
GO
EXECUTE sys.sp_cdc_enable_table
    @source_schema = N'dbo'
  , @source_name = N'eco_data_fin'
  , @role_name = N'cdc_Admin'--可以自动创建
  , @capture_instance=DEFAULT
GO


EXECUTE sys.sp_cdc_enable_table
    @source_schema = N'dbo'
  , @source_name = N'eco_data_ind_aricultural'
  , @role_name = N'cdc_Admin'--可以自动创建
  , @capture_instance=DEFAULT
GO
EXECUTE sys.sp_cdc_enable_table
    @source_schema = N'dbo'
  , @source_name = N'eco_data_ind_automobile'
  , @role_name = N'cdc_Admin'--可以自动创建
  , @capture_instance=DEFAULT
GO
EXECUTE sys.sp_cdc_enable_table
    @source_schema = N'dbo'
  , @source_name = N'eco_data_ind_biologicalmedicine'
  , @role_name = N'cdc_Admin'--可以自动创建
  , @capture_instance=DEFAULT
GO


EXECUTE sys.sp_cdc_enable_table
    @source_schema = N'dbo'
  , @source_name = N'eco_data_ind_buildingmaterials'
  , @role_name = N'cdc_Admin'--可以自动创建
  , @capture_instance=DEFAULT
GO
EXECUTE sys.sp_cdc_enable_table
    @source_schema = N'dbo'
  , @source_name = N'eco_data_ind_cateringtourism'
  , @role_name = N'cdc_Admin'--可以自动创建
  , @capture_instance=DEFAULT
GO
EXECUTE sys.sp_cdc_enable_table
    @source_schema = N'dbo'
  , @source_name = N'eco_data_ind_chemical'
  , @role_name = N'cdc_Admin'--可以自动创建
  , @capture_instance=DEFAULT
GO
EXECUTE sys.sp_cdc_enable_table
    @source_schema = N'dbo'
  , @source_name = N'eco_data_ind_commercialtrade'
  , @role_name = N'cdc_Admin'--可以自动创建
  , @capture_instance=DEFAULT
GO
EXECUTE sys.sp_cdc_enable_table
    @source_schema = N'dbo'
  , @source_name = N'eco_data_ind_culture'
  , @role_name = N'cdc_Admin'--可以自动创建
  , @capture_instance=DEFAULT
GO
EXECUTE sys.sp_cdc_enable_table
    @source_schema = N'dbo'
  , @source_name = N'eco_data_ind_electronic'
  , @role_name = N'cdc_Admin'--可以自动创建
  , @capture_instance=DEFAULT
GO
EXECUTE sys.sp_cdc_enable_table
    @source_schema = N'dbo'
  , @source_name = N'eco_data_ind_energy'
  , @role_name = N'cdc_Admin'--可以自动创建
  , @capture_instance=DEFAULT
GO
EXECUTE sys.sp_cdc_enable_table
    @source_schema = N'dbo'
  , @source_name = N'eco_data_ind_financialservices'
  , @role_name = N'cdc_Admin'--可以自动创建
  , @capture_instance=DEFAULT
GO
EXECUTE sys.sp_cdc_enable_table
    @source_schema = N'dbo'
  , @source_name = N'eco_data_ind_foodbeverage'
  , @role_name = N'cdc_Admin'--可以自动创建
  , @capture_instance=DEFAULT
GO



http://www.cnblogs.com/lyhabc/p/3383484.html