Friday, February 24, 2012

How to delete an orphaned push subscription

On server1 I created a push subscription to server2. I deleted the
subscription from server1, but server2 still shows it.
I have referred to SQL Server 2000 Books OnLine topics "How to Delete
a Push
Subscription" and "How to Delete a Pull Subscription", but they are of
no help because they only show how to remove it from server1.
Does anyone know how to go about fixing this?
Thanks!
If the database on server2 is not a subscriber to any other publications and
doesn't itself have any publications, then try running
sp_removedbreplication.
HTH,
Paul Ibison

No comments:

Post a Comment