MSSQL_ENG003724

Message Details

Product Name

SQL Server

Product Version

10.0

Product Build Number

 

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.

See Also

Concepts

Errors and Events Reference (Replication)