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

Artikel-id: 3155558 - Laatst bijgewerkt: 15 aug. 2016 - Revisie: 1

Feedback