SQL Server Error Code – 22978 could not update the cdc.captured_column

In this blog post, you’ll learn more about the SQL Server Error Code 22978 and the error message description that is shown

SQL Server Error Code

22978

SQL Server Error Description for the Code :22978

Could not update the cdc.captured_columns entry for column ‘%s’ of change table ‘%s’ to reflect a data type change in the corresponding column of the source table ‘%s’. Change Data Capture column meta data for table ‘%s’ no longer accurately reflects the source table. Refer to previous errors in the current session to identify the cause and correct any associated problems.