Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a bidirectional merge replication. I had failure constraints because the primary key was just integer. I change the primary key to the old primary key + a location identifier.The problem is how can I reinsert the old rows of conflict table ( that I can correct manually from MSmerge_conflict_) to the publishers and subscribers. can you help me please?

sorry for making faults, I'm not english speaker

share|improve this question
Have you tried anything? Are you getting errors? – Max Vernon Apr 2 '13 at 17:56
yes now I have not primary key conflicts because I added a location identifier. I edited the MSmerge_conflict_ to correct the old rows but I have no idea to reinsert the corrected rows without doing it one by one (with command update or conflict viewer) – liliane Apr 3 '13 at 9:01

You can use the Conflict Viewer to submit the winning or losing row.

share|improve this answer
thanks brandon but assuming there is 1000 losing rows there is no stored procedure or command that can be used? – liliane Apr 3 '13 at 8:53
You may want to look at this:… – Brandon Williams Apr 3 '13 at 16:11
There is a chance that it doesn't work for you since these are primary key conflicts. You could however modify the script to delete one of the conflicting rows. – Brandon Williams Apr 3 '13 at 16:12
thanks but the script delete the loosing rows even if I corrected them. I want to reinsert them into the publisher.I am trying to that by using sql requests. is there a means to say to the merge agent that these lines are corrected and must be reinserted – liliane Apr 5 '13 at 13:36

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.