Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Product Name

SQL Server

Event ID


Event Source



SQL Server Database Engine

Symbolic Name

Message Text

Cannot %S_MSG the %S_MSG '%.*ls' because it is being used for replication.

When objects in a database are replicated, they are marked as replicated in the system table sysarticles (for snapshot and transactional publications) or sysmergearticles (for merge publications). If you attempt drop a replicated object, this error is raised.

Ensure the database object is not replicated before attempting to drop it. For example:

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.

Community Additions

© 2016 Microsoft