Deleting subscription

• hendrasd

  SSC-Addicted

  Points: 413

  More actions

  July 16, 2003 at 7:57 pm

  #82100

  I set up a transactional replication between two server with push subscription and updating subscriber. Server A act as publisher and also as distributor. Is there any way to delete subscription on Server B (subscriber) by doing it on Server B, not on publisher (Server A) ? Thanks in advance ...

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  July 17, 2003 at 10:35 am

  #465899

  The only way is to delete the sp sp_dropsubscription on the publisher in the published db.

  So, you coud execute the sp remotely from the subscribers, if you have the publisher setted up as a linked server from the subscriber