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
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.