How to disable change data capture (CDC) on a table?

This article illustrates how to disable Change Data Capture on a table that has already CDC enabled in a database.

T-SQL:

USE Your_Database_Name
GOEXEC sys.sp_cdc_disable_table
@source_schema = N'dbo',--Source Schema, if used different, please replace it with your own schema
@source_name = N'YourTableName', --Table name that needs CDC disable on
@capture_instance = N'dbo_YourTableName' -- This would be combination of your schema and tableName
GO
 
 
 

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.