how to delete a single publication

• shanila_minnu

  Hall of Fame

  Points: 3465

  More actions

  June 4, 2009 at 3:40 am

  #132929

  i am unable to delete the publication...it is throwing the error "the publication does not exist" but it is visible under replication monitor

• manolomalaga

  SSCommitted

  Points: 1697

  More actions

  June 8, 2009 at 2:30 am

  #1005952

  Try sp_droppublication @publication='publicationName', @ignore_distributor = 1

• Eswin

  SSCrazy Eights

  Points: 8320

  More actions

  June 8, 2009 at 2:47 am

  #1005959

  Check out:

  http://msdn.microsoft.com/en-us/library/ms146927.aspx%5B/url%5D

  Tanx 😀