How do I cleanup system created conflict items

  • Have a replicated db running for several years.  We have the luxury to take it offline occassionally and make major changes (table structure, etc.), and reset up the publication and subscriptions, etc.  It has over time accumulated almost 3000 system created conflict tables, especially in the stored procedures (SP's).  THe db only has 200 tables and around 60 views and SP's.  The next time I take it offline and make changes, I would like to clean up these conflict items if possible.  It it possible and if so how?  Thanks much!

  • This was removed by the editor as SPAM

  • I had the same issues a while ago and created a  script which cleans all the leftovers of merge replication.

    I don't like to post it because it's quite rough and can easily damage your database, but if you send me an email I can send it to you on your own risk.

    Markus

    [font="Verdana"]Markus Bohse[/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply