"Brett" <Brett@discussions.microsoft.com> wrote in message
news:C9C85C02-8750-4FBA-843B-AA0A78E5A8DC@microsoft.com...
> This is SQL 2000
>
> "Brett" wrote:
>
>> Before I got here a publisher with push subscriptions was removed. I
>> can't
>> delete the subscriptions at the subscribers. How do I remove these
>> subscriptions?
>>
>> ps
>> Thank you but please don't refer me to an article telling me to drop the
>> subcription at the publisher because it doesn't exist any more.
>>

"Hilary Cotter" wrote:

> delete the contents of MSreplication_subscriptions and
> MSsubscription_agents on the subscriber.
>
> --
> 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
>
>
>
> "Brett" <Brett@discussions.microsoft.com> wrote in message
> news:C9C85C02-8750-4FBA-843B-AA0A78E5A8DC@microsoft.com...
> > This is SQL 2000
> >
> > "Brett" wrote:
> >
> >> Before I got here a publisher with push subscriptions was removed. I
> >> can't
> >> delete the subscriptions at the subscribers. How do I remove these
> >> subscriptions?
> >>
> >> ps
> >> Thank you but please don't refer me to an article telling me to drop the
> >> subcription at the publisher because it doesn't exist any more.
> >>
>
>