Error enabling CDC for table. - by John81

Status : 

  External<br /><br />
		This item may be valid but belongs to an external system out of the direct control of this product team.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 793911 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 7/14/2013 2:46:47 PM
Access Restriction Public


When attempting to enable Change Data Capture (CDC) for a table, I receive the following error:
Msg 22832, Level 16, State 1, Procedure sp_cdc_enable_table_internal, Line 623

Apparently, this was a known issue in v2008. I tried the work around specified in but it didn't help. 

Select @@version

Microsoft SQL Server 2012 - 11.0.2100.60 (X64) 
	Feb 10 2012 19:39:15 
	Copyright (c) Microsoft Corporation
	Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

Sign in to post a comment.
Posted by John81 on 7/25/2013 at 6:26 AM
I had to work with MS support to get this resolved. The problem was caused by an update to the .net framework on the server. The server needed be rebooted to complete the update.

After rebooting the server I was able to successfully enable CDC on the table. A very simple solution.

I hope this helps some else that experiences the same problem.