Errors enabling and disabling Change Data Capture for 1 table

• oradbguru

  Hall of Fame

  Points: 3126

  More actions

  November 5, 2020 at 1:58 pm

  #3804580

  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

• Site Owners

  SSC Guru

  Points: 80338

  More actions

  November 6, 2020 at 2:10 pm

  #3804989

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.