| Event Information | According to Microsoft
Cause:
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
Resolution:
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. |
