MSSQL_ENG003724

Message Details

Product Name

SQL Server

Product Version

9.0

Product Build Number

9.00.1399.60

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

Cause and Resolution of Replication Errors

Help and Information

Getting SQL Server 2005 Assistance