Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2012
Product Documentation
Books Online for SQL Server 2012
Replication
Technical Reference
Errors and Events Reference
MSSQL_ENG002601
MSSQL_ENG002627
MSSQL_ENG003165
MSSQL_ENG003724
MSSQL_ENG004929
MSSQL_ENG014005
MSSQL_ENG014010
MSSQL_ENG014114
MSSQL_ENG014117
MSSQL_ENG014120
MSSQL_ENG014121
MSSQL_ENG014144
MSSQL_ENG014150
MSSQL_ENG014151
MSSQL_ENG014152
MSSQL_ENG014157
MSSQL_ENG014160
MSSQL_ENG014161
MSSQL_ENG014162
MSSQL_ENG014163
MSSQL_ENG014164
MSSQL_ENG014165
MSSQL_ENG018456
MSSQL_ENG018752
MSSQL_ENG020554
MSSQL_ENG020557
MSSQL_ENG020572
MSSQL_ENG020574
MSSQL_ENG020575
MSSQL_ENG020596
MSSQL_ENG020598
MSSQL_ENG021075
MSSQL_ENG021076
MSSQL_ENG021286
MSSQL_ENG021330
MSSQL_ENG021331
MSSQL_ENG021385
MSSQL_ENG021797
MSSQL_ENG021798
MSSQL_ENG024070
MSSQL_REPL020011
MSSQL_REPL027056
MSSQL_REPL027183
MSSQL_REPL-2147198698
MSSQL_REPL-2147199363
MSSQL_REPL-2147199371
MSSQL_REPL-2147199376
MSSQL_REPL-2147199389
MSSQL_REPL-2147199390
MSSQL_REPL-2147199398
MSSQL_REPL-2147199401
MSSQL_REPL-2147199402
MSSQL_REPL-2147199416
MSSQL_REPL-2147199417
MSSQL_REPL-2147199420
MSSQL_REPL-2147199429
MSSQL_REPL-2147199431
MSSQL_REPL-2147199464
MSSQL_REPL-2147199466
MSSQL_REPL-2147200928
MSSQL_REPL-2147200940
MSSQL_REPL-2147200941
MSSQL_REPL-2147200950
MSSQL_REPL-2147200953
MSSQL_REPL-2147200968
MSSQL_REPL-2147200980
MSSQL_REPL-2147200989
MSSQL_REPL-2147200990
MSSQL_REPL-2147201001
MSSQL_REPL-2147201005
MSSQL_REPL-2147201007
MSSQL_REPL-2147201021
Expand Minimize
This topic has not yet been rated - Rate this topic

MSSQL_ENG004929

SQL Server 2012

Product Name

SQL Server

Product Version

10.0

Product Build Number

 

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

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.