Delete Subscription

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Samuel Shulman - 28 Sep 2006 19:38 GMT

I am still struggling to delete a subscription so I can set another one to
that server

I believe that normally that would be listed in the Properties Page of the
Publisher, but it doesn't

How can I still delete it

Thank you,
Samuel

Reply to this Message

Hilary Cotter - 29 Sep 2006 03:06 GMT

Did you try to issue a sp_dropsubscription 'Publicationname','articlename/or
all','Subscribername','subscriptiondatabase'

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

>I am still struggling to delete a subscription so I can set another one to
>that server
[quoted text clipped - 6 lines]
> Thank you,
> Samuel

Reply to this Message