Data Replication
- Data Replication 9.7.0 HotFix 1
- All Products
use[database_name]; EXECUTE sys.sp_cdc_enable_db; use[database_name]; declare @table_namenchar(characters); set @table_name=(SELECTtable_namefrom sys.objects where object_id=object_id) ; execute sys.sp_cdc_enable_table @schema_name= N'dbo' , @source_name= @table_name, @role_name= NULL, @capture_instance= N'dbo_table_name_sequence_ID';
use[database_name]; declare @table_namenchar(characters); set @table_name=(SELECTtable_namefrom sys.objects where object_id=object_id) ; execute sys.sp_cdc_disable_table @schema_name= N'dbo' , @source_name= @table_name, @role_name= NULL, @capture_instance= N'dbo_table_name_sequence_ID';