Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

MSSQL_ENG004929

Product Name

SQL Server

Product Version

9.0

Product Build Number

9.00.1399.60

Event ID

4929

Event Source

MSSQLSERVER

Component

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 Adding Articles to and Dropping 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.