Wish i didnt have to move this database
I have a transactional/ Push subscription. Publisher is on one server. Distributor/subscriber on another.
I right click on Replication on Publisher database and it gives me a pop-up with the name of the distributor,subscriber . ALL is fine so far.
Is there anyway to drop the Publisher's reference
to this Distributor WITHOUT
actually deleting/removing the distributor database with sp_dropdistributor/sp_dropdistributiondb ? beause I want the Publisher to reference a new distributor.