TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

MSSQL_ENG004929

 

Applies To: SQL Server 2016

Product NameSQL Server
Event ID4929
Event SourceMSSQLSERVER
ComponentSQL Server Database Engine
Symbolic Name
Message TextCannot 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.

Errors and Events Reference (Replication)

Community Additions

ADD
Show:
© 2016 Microsoft