Drop single article without dropping subscriber

• Alone

  Right there with Babe

  Points: 783

  More actions

  May 15, 2010 at 12:13 am

  #97286

  Hi I need to drop one article and add it back in transactional replication as it is not sync. Please let me know SQL command to drop single article with out dropping subscription.

  Thanks, Litu

• happycat59

  One Orange Chip

  Points: 29389

  More actions

  May 16, 2010 at 10:35 pm

  #1168106

  Have a look at sp_dropsubscription and sp_droparticle.

  Better still, if you only have the one article that is out of sync, try sp_reinitsubscription

  Check out Books Online for the details of these commands