禁用表数据捕获
EXEC sys.sp_cdc_disable_table
'dbo','Equipment','all'
--验证表是否确实被禁用
SELECt is_tracked_by_cdc
FROM sys.tables
WHERE name='Equipment' AND schema_id=SCHEMA_Id('dbo')
禁用数据库
EXEC sys.sp_cdc_disable_db
禁用表数据捕获
EXEC sys.sp_cdc_disable_table
'dbo','Equipment','all'
--验证表是否确实被禁用
SELECt is_tracked_by_cdc
FROM sys.tables
WHERE name='Equipment' AND schema_id=SCHEMA_Id('dbo')
禁用数据库
EXEC sys.sp_cdc_disable_db