Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2012
Product Documentation
Books Online for SQL Server 2012
Replication
Technical Reference
Errors and Events Reference
MSSQL_ENG002601
MSSQL_ENG002627
MSSQL_ENG003165
MSSQL_ENG003724
MSSQL_ENG004929
MSSQL_ENG014005
MSSQL_ENG014010
MSSQL_ENG014114
MSSQL_ENG014117
MSSQL_ENG014120
MSSQL_ENG014121
MSSQL_ENG014144
MSSQL_ENG014150
MSSQL_ENG014151
MSSQL_ENG014152
MSSQL_ENG014157
MSSQL_ENG014160
MSSQL_ENG014161
MSSQL_ENG014162
MSSQL_ENG014163
MSSQL_ENG014164
MSSQL_ENG014165
MSSQL_ENG018456
MSSQL_ENG018752
MSSQL_ENG020554
MSSQL_ENG020557
MSSQL_ENG020572
MSSQL_ENG020574
MSSQL_ENG020575
MSSQL_ENG020596
MSSQL_ENG020598
MSSQL_ENG021075
MSSQL_ENG021076
MSSQL_ENG021286
MSSQL_ENG021330
MSSQL_ENG021331
MSSQL_ENG021385
MSSQL_ENG021797
MSSQL_ENG021798
MSSQL_ENG024070
MSSQL_REPL020011
MSSQL_REPL027056
MSSQL_REPL027183
MSSQL_REPL-2147198698
MSSQL_REPL-2147199363
MSSQL_REPL-2147199371
MSSQL_REPL-2147199376
MSSQL_REPL-2147199389
MSSQL_REPL-2147199390
MSSQL_REPL-2147199398
MSSQL_REPL-2147199401
MSSQL_REPL-2147199402
MSSQL_REPL-2147199416
MSSQL_REPL-2147199417
MSSQL_REPL-2147199420
MSSQL_REPL-2147199429
MSSQL_REPL-2147199431
MSSQL_REPL-2147199464
MSSQL_REPL-2147199466
MSSQL_REPL-2147200928
MSSQL_REPL-2147200940
MSSQL_REPL-2147200941
MSSQL_REPL-2147200950
MSSQL_REPL-2147200953
MSSQL_REPL-2147200968
MSSQL_REPL-2147200980
MSSQL_REPL-2147200989
MSSQL_REPL-2147200990
MSSQL_REPL-2147201001
MSSQL_REPL-2147201005
MSSQL_REPL-2147201007
MSSQL_REPL-2147201021
Expand Minimize
This topic has not yet been rated - Rate this topic

MSSQL_ENG014121

SQL Server 2012

Product Name

SQL Server

Product Version

10.0

Product Build Number

 

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.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.