February 1, 2010 at 9:26 am
Hi,
SQL 2000 SP4 server.
I have a published database, transactional replication with a number of subscribers.
Over time a number of the subscribers have been deleted. When I delete them they go from the publisher properties under replication monitor and from the distribution agents as expected, so they are definitely dropped, but every subscriber there has ever been still appears in the subscription list under the replication folder in EM with a Last action of 'the process was successfully stopped'
For the sake of tidiness how do i delete them out of the subscription list?
---------------------------------------------------------------------
February 2, 2010 at 3:44 pm
How did you delete them from replication?
You should be able to use system stored procedures to remove the subscription. Just remember the sp needs to be ran from the location of the publication. So if it is a push it needs to be done at the publisher; if it is a pull subscription it needs to be done at the subscriber.
Joie Andrew
"Since 1982"
February 3, 2010 at 3:45 am
Joie,
thanks for the reply. I dropped the subscriptions via the replication monitor wizard. So If I did it manually and used sp_dropsubscription that would also remove it from the subscription list?
---------------------------------------------------------------------
February 3, 2010 at 5:40 am
That should work if it is a push subscription, and it will need to be ran at the publisher. If it is a pull subscription, then you will need to run sp_droppullsubscription from the subscription.
Joie Andrew
"Since 1982"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply