| Event Information | CAUSE:
You are trying to drop a database that is configured for distribution and is associated with one or more publisher instances. Each instance of SQL Server can be associated with one and only one distribution database for all of its replication, but each distribution database can be associated with one or more publisher instances.
RESOLUTION:
To drop a distribution database you must first completely disable publishing for each instance of SQL Server that is associated with that distribution database. Once no publisher instances are associated with the distribution database, execute the command to drop it. |
