What do you mean by you still see the subscription on ServerB>
All objects replicated by the replication process will remain on the
subscriber, once you drop the subscription.
On Feb 5, 10:07 am, Francesco wrote:
> Hi everyone.
>
> I have an SQL Server 2000 "A" pushing a transactional replica of a
> database on an SQL Server 2000 "B".
> Today i removed the subscription from server "A" (publisher), but i
> still see the subscription on the server "B" (subscriber).
> I tried
>
> sp_subscription_cleanup 'publisher', 'publisher_db'
>
> the command runs, no effect, the subscription is still there. What am i
> doing wrong?
>
> Thank you for your time.
>
> --
> Francesco
>> Stay informed about: Remove push subscription from subscriber