MSSQL_ENG003724

Applies to: SQL Server Azure SQL Managed Instance

Message Details

Attribute Value
Product Name SQL Server
Event ID 3724
Event Source MSSQLSERVER
Component SQL Server Database Engine
Symbolic Name
Message Text Cannot %S_MSG the %S_MSG '%.*ls' because it is being used for replication.

Explanation

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.

User Action

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.