January 12, 2023 at 12:47 pm
We performed a drop on one of our CDC Tables when we should have performed a sp_cdc_disable_table . Now when we try to create the CDC Table via sp_cdc_enable_table and specifying the @Capture_Instance name we get the following error:
Could not create a capture instance because the capture instance name ' ' already exists in the current database. Specify an explicit unique name for the parameter @capture_instance.
So by performing a drop on this CDC Table it appears that SQL Server is confused cause it's thinking this CDC Table already exists when it doesn't. The only way I could make this work is execute sp_cdc_enable_table with a @capture_instance name different than the original. Then it worked and created the CDC Table. Maybe this is my only workaround?
January 13, 2023 at 1:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply