Unanswered: How to get rid of ONLY ONE publications?
I have got a Publisher with 5 different publications (different tables on each). One of them publicates only one table. I delete that one and then create a new one with the same table and a new table. My final purpose is adding a new table to an existing publication. When I run the merge agent, I got the error "cannot drop one or more tables because they are being used by another publications". I cannont use the sp sp_removedbreplication 'database_name' because I do not want to get rid of all of them, just "remake" one of the. The suscriber is the same for all and all of them are merge.
Thanks in advanced for your ideas.