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


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


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


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.


Learn about the terminology that Microsoft uses to describe software updates.

ID článku: 3155558 – Posledná kontrola: 15. 8. 2016 – Revízia: 1