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
I enjoy photographing the outdoors. I enjoy taking all kinds of pictures. It's my pastime. One interesting thing called ISO piques my interest. I learned that, provided the aperture and shutter speed are unchanged, doubling your ISO value makes your image brighter by one stop, while halving it makes it brighter by one stop Advice of Skylum . The idea behind aperture and shutter speed is the same.
ReplyDelete