MSSQL_ENG004929
Applies to:
SQL Server
Azure SQL Managed Instance
Message Details
Attribute | Value |
---|---|
Product Name | SQL Server |
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 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.
See Also
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om