Post reply

Replication

  • October 20, 2004 at 8:06 am

    #162522

    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

    #527364

    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

    #527472

    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