I dropped a cdc table by mistake now am trying to disable cdc and renable on the main table but am getting the following error:
Msg 22926, Level 16, State 1, Procedure sys.sp_cdc_verify_capture_instance, Line 47 [Batch Start Line 2]
Could not create a capture instance because the capture instance name ‘dbo_ConnectionLogs_cdc_Test’ already exists in the current database. Specify an explicit unique name for the parameter @capture_instance.
What is the workaround here?