FIX: "Cannot alter column" error after a database is restored to SQL Server

Symptoms

Assume that you back up a database that has change data capture enabled. You restore this database to an instance of SQL Server that does not support change data capture. When you try to rename a column in a table in the database, you receive an error message that resembles the following:
Msg 4928, Level 16, State 1, Procedure sp_rename, Line 629
Cannot alter column <column name> because it is 'enabled for Replication or Change Data Capture'.

Resolution

The issue was first fixed in the following cumulative update of SQL Server:
Recommendation: Install the latest cumulative update for SQL Server

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.
Eigenschaften

Artikelnummer: 3155558 – Letzte Überarbeitung: 15.08.2016 – Revision: 1

Feedback