Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Valencia - Spain

    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.

  2. #2
    Join Date
    Aug 2002
    Use sp_droppublication and refer to books online for more information.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts