MSSQL_ENG014120

Message Details

Product Name

SQL Server

Product Version

10.0

Product Build Number

 

Event ID

14120

Event Source

MSSQLSERVER

Component

SQL Server Database Engine

Symbolic Name

Message Text

Could not drop the distribution database '%s'. This distributor database is associated with a Publisher.

Explanation

The distribution database stores metadata and history data for all types of replication and transactions for transactional replication. This error occurs if you attempt to drop a distribution database that is associated with one or more Publishers.

User Action

To drop a distribution database you must first drop the association between the Distributor and the Publisher. For more information, see sp_dropdistpublisher (Transact-SQL).

See Also

Concepts

Errors and Events Reference (Replication)

Configure Distribution