Applies To: SQL Server 2016
|Product Name||SQL Server|
|Component||SQL Server Database Engine|
|Message Text||Could not drop the distribution database '%s'. This distributor database is associated with a Publisher.|
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.
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).