How to remove a push subscription?

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?
Thanks,
Hi,
to dtop a pull subscription you can use:
sp_droppullsubscription system stored procedures.
hope it works fine with you.
SaeedA
"FYK" wrote:

> 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?
> Thanks,
|||Hi,
You can use :
sp_dropsubscription, you can see BOL for more details
SaeedA
"FYK" wrote:

> 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?
> Thanks,