Deleting redundant Subscriptions

Question

Post reply

Deleting redundant Subscriptions

Zara Saxon

Old Hand

Points: 313
More actions
February 7, 2006 at 9:15 am

#168070

Hi,
I have a list of old Subscriptions on a few servers, I would like to clear them down for ease and to aide the support team. Any ideas on how to delete these?

Many Thanks
Zara

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

TriggerMe SSChampion Points: 11752 More actions · Answer 1

Unless this is some sort of a joke, just go into EM and right click the Subscription and DELETE it!

Kindest Regards,

Zara Saxon Old Hand Points: 313 More actions · Answer 2

It isnt a joke the only option I have is Help when I Right Click on the old Subscriptions. Obviously if it was as simple as a Right Click Delete I wouldnt be asking!

Rob-242869 SSC Enthusiast Points: 130 More actions · Answer 3

Dont select multiple subscriptions when u delete you have to delete them one at a time.

TriggerMe SSChampion Points: 11752 More actions · Answer 4

If help is all you have when you rigt click then you obviously do not have permissions to drop subscriptions.

Kindest Regards,

Jen-169507 Right there with Babe Points: 776 More actions · Answer 5

Use sp_dropsubscription so you don't have to browse EM, below is the minimum permission needed to execute the command.

from BOL:

Permissions

Only members of the sysadmin fixed server role or db_owner fixed database role can execute sp_dropsubscription. A remote connection from the Subscriber can drop a subscription to an existing publication or article.

HTH

Deleting redundant Subscriptions

Permissions

Cookies on SQLServerCentral