October 20, 2004 at 8:06 am
Hi,
What I have is SQL 2000 server sp3 running on a window 2000 server sp4.
What happen is I drop replication. On two of the subscription servers
the config tables are still there. I tried to delete them and it said "YOU
TRIED TO DELETE ONE OR MORE SYSTEM OBJECTS. THEY WERE NOT DELETED". I want
to clean up the subscription database. Can you tell me how I can delete the config
tables.
Thanks
Mark
October 20, 2004 at 2:01 pm
First you should remove all the subscriptions to the publication (check sp_dropsubscription, sp_subscription_cleanup, sp_droppullsubscription), then you should drop the publications (with sp_droppublication) and then you can disable replication in the distributor/publisher, you should use the wizard here.
Check in BOL for exact parameters.
October 21, 2004 at 8:43 am
If the subscriber's database is no longer involved in replication - either as a subscriber or as a publisher - try running sp_removedbreplication at the subscriber.
HTH,
Paul Ibison (SQL Server MVP)
Paul Ibison
Paul.Ibison@replicationanswers.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply