SQL Server Performance Forum – Threads Archive

How to drop the Push Subscriptions

Hi,
How to drop the Push Subscriptions from my database. i setup the Replication from svr1 and svr2 I could drop all from the svr1 But i cant drop the Subscriptions from svr2 Regards
Srini

---

Try using as defined in BOL
Execute sp_dropsubscription to delete the subscription.
Execute sp_dropsubscriber to remove the registration entry of the Subscriber.
Note It is not necessary to drop a Subscriber unless you are dropping the last publication to which it subscribes.
To delete a push subscription to a transactional publication Execute sp_dropsubscription to delete the subscription.
Execute sp_dropsubscriber to remove the registration entry of a Subscriber.
Note It is not necessary to drop a Subscriber unless you are dropping the last publication to which it subscribes.
To delete a push subscription to a merge publication Execute sp_dropmergesubscription to delete the subscription.
Execute sp_mergesubscription_cleanup to remove merge configuration meta data for all merge articles in the subscription database.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>