Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

MSSQL_ENG014121

Product Name

SQL Server

Product Version

9.0

Product Build Number

9.00.1399.60

Event ID

14121

Event Source

MSSQLSERVER

Component

SQL Server Database Engine

Symbolic Name

Message Text

Could not drop the Distributor '%s'. This Distributor has associated distribution databases.

A SQL Server instance that is configured as a Distributor cannot be removed from the role of Distributor because there are distribution databases associated with the instance. This error occurs if you attempt to drop a distribution database that is associated with one or more Publishers.

To find the names of any Publishers and distribution databases associated with this Distributor, execute sp_helpdistpublisher (Transact-SQL) from any database on the Distributor.

Execute sp_dropdistributiondb (Transact-SQL) for any distribution databases associated with this Distributor. After all distribution database associations are removed, you can disable distribution. For more information, see Disabling Publishing and Distribution.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.