Hello, when we try to enable CDC on a table that is dropped and recreated each night, we get the below error:
Msg 22926, Level 16, State 1, Procedure sp_cdc_verify_capture_instance, Line 36 [Batch Start Line 0]Could not create a capture instance because the capture instance name 'dbo_appt_slots' already exists in the current database. Specify an explicit unique name for the parameter @capture_instance.
I tried to run this and it does not resolve it either.
EXEC sys.sp_cdc_disable_table @source_schema=N'dbo', @source_name=N'appt_slots', @capture_instance=N'ALL';
Any suggestions on how to clean this up? There seems to be orphan CDC entries for this table.
Dave K