sql server replication: How to remove a push subscription? -- sql server replication

How to remove a push subscription?

FYK
6/28/2005 7:45:03 PM

sql server replication:
I have a publication within a transactional replication with a push
subscription. I had deleted the subscription on the Publisher through the EM.
And Publisher EM showed the subscription is removed. But when I checked the
Subscriber EM, the subscription is still there under the
Replication\Subscriptions, and it seems there is no way to remove it on
Subscriber EM. Can someone please help me on this? How do I remove it on the
subscriber?

RE: How to remove a push subscription?

Saeed Abd Al-Ati
6/30/2005 2:31:01 AM

Hi,

to dtop a pull subscription you can use:
sp_droppullsubscription system stored procedures.
hope it works fine with you.

SaeedA

[quoted text, click to view]

RE: How to remove a push subscription?

Saeed Abd Al-Ati
6/30/2005 2:33:03 AM

Hi,

You can use :

sp_dropsubscription, you can see BOL for more details

SaeedA

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.