FIX: "Could not find stored procedure 'sys.sp_cdc_parse_captured_column_list'" error in SQL Server 2016

Symptoms
Assume that you enable Change Data Capture (CDC) for a table by executing the stored procedure sp_cdc_enable_table in Microsoft SQL Server 2016. When you use a not null value for the @captured_column_list parameter, you may receive the following error message:
Could not find stored procedure 'sys.sp_cdc_parse_captured_column_list'.
Msg 22942, Level 16, State 1, Procedure sp_cdc_enable_table_internal, Line 304
Columns specified in the captured column list could not be mapped to columns in source table 'dbo.TableName'.

Resolution

Download information

The following file is available for download from the Microsoft Download Center:
DownloadDownload the Critical Update for SQL Server 2016 MSVCRT Prerequisites now.

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base: 
119591 How to obtain Microsoft support files from online services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file. 
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
References
Learn about the terminology that Microsoft uses to describe software updates.
Properties

Article ID: 3166120 - Last Review: 06/12/2016 08:58:00 - Revision: 1.0

Microsoft SQL Server 2016 Developer, Microsoft SQL Server 2016 Enterprise, Microsoft SQL Server 2016 Enterprise Core, Microsoft SQL Server 2016 Express, Microsoft SQL Server 2016 Standard, Microsoft SQL Server 2016 Web

  • kbqfe kbfix kbsurveynew kbexpertiseadvanced KB3166120
Feedback