I have two databases on a server, both of which contain Publications. I am wanting to drop one of the databases - when I try to I get the following error message ...
"Cannot drop database <db_name> because it is being used for replication."
If I use the Tools>>Replication>>Disable Publishing in Enterprise Manager that will disable Publishing on both databases, which is not what I want as the other database must stay online and be using replication all the time.
How do I remove this unwanted published database?
Thanks in advance.