Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Product Name

SQL Server

Event ID


Event Source



SQL Server Database Engine

Symbolic Name

Message Text

Cannot alter the %S_MSG '%.*ls' because it is being published for replication.

This error typically occurs if you attempt to drop the primary key constraint on a table that is published for transactional replication. Transactional replication requires a primary key for each published table; therefore the constraint cannot be dropped.

To drop the constraint, first drop the article associated with the table. For more information, see Add Articles to and Drop Articles from Existing Publications. If this error occurs in a database that is not replicated, execute sp_removedbreplication (Transact-SQL) to ensure objects in the database are not marked as replicated.

Community Additions

© 2015 Microsoft