Problem with the sync order RRS feed

  • Question

  • Hi,

    I have one problem that I don't know how to resolve, when I syncronize my databases (I configure a merge replication on SQL Server 2008), sometimes have conflicts, because one row which has a column referencing another column on another table is sincronized after the reference key, so I have a FK conflict. I configure the merge agent profile parameter DestThread to 1 and still occurs conflicts. There is any way to force that only the corresponding FK exists? Or there is a way to configure the conflisct to retry de insertion more times?

    Lucas Yoshida
    Wednesday, July 8, 2009 8:07 PM


  • There is article order property in sp_addmergearticle, you can give that a try.  You can also just rerun the merge agent.
    • Marked as answer by Lucas Yoshida Tuesday, January 5, 2010 12:12 PM
    Thursday, July 9, 2009 4:48 AM