This topic has not yet been rated - Rate this topic

MSSQL_ENG003724

SQL Server 2012

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 the error occurs in the publication database, drop the article from the publication before dropping the object. For more information, see Add Articles to and Drop Articles from Existing Publications.
If the error occurs in the subscription database, drop the subscription before dropping the object. For more information, see Subscribe to Publications. For subscriptions to transactional publications, it is possible to drop the subscription to an individual article rather than the entire publication. For more information, see sp_dropsubscription (Transact-SQL).

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.

Concepts

Errors and Events Reference (Replication)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD