This topic has not yet been rated - Rate this topic

MSSQL_ENG004929

SQL Server 2005

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.

Explanation

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.

User Action

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.

Concepts

Cause and Resolution of Replication Errors

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD