Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Posts
    1

    Unhappy Unanswered: Removed publication problem

    Hi all!

    I had a publication on my SQL Server 2000. I deleted the publication
    from the Publications 'folder' in the Enterprise Manager, and then Disabled Publishing And Distribution from the Tools menu.
    The problem is that there are some leftovers in the database I created the publication from. There are tables like "conflict_[Publication Name]_[Table Name]" and some stored procedures too.
    These items i cannot delete: I get the error "You tried to delete one or more system objects. They were not deleted".

    How can I cleanup my database? I do not want these leftovers...

    Any ideas?

    Thanks..

  2. #2
    Join Date
    Aug 2003
    Posts
    1

    Arrow Re: Removed publication problem

    hi.. I've asimilar problem derived from an upgrade to sql server 2000 of a replicated sql server 7 database.
    Did you find an answer for you question?

  3. #3
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Did you try to use sps below?

    sp_dropmergepublication
    sp_dropmergepullsubscription
    sp_droppullsubscription
    .....................................

    You can find another usefull sps for cleaning your DB from replication...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •