MSSQL_ENG014120

Message Details

Product Name

SQL Server

Product Version

9.0

Product Build Number

9.00.1399.60

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

Cause and Resolution of Replication Errors

Other Resources

Configuring Distribution

Help and Information

Getting SQL Server 2005 Assistance