Friday, March 30, 2012

Resolver is either missing or Incorrect

Hi all sql guru's

I'm having this problem for a while now and can't find any solid answer on the net for it.

I have 2 server in diffrent location ( +- 1200k's) away from eachother. When the msmerge agent run it return the following error and return the status as successfull with the following error information:

(The colum information specified for the MS SQL Server maximum conflict resolver) Resolver is either missing or incorrect. I've change every single article to "Latest chagne wins". Any suggestion. I happend when the power failed and the server got restarted.

If you are using the maximum conflict resolver, you need to specify which column to look for this max value. Without this information, the resolver does not know how to resolve the conflict. Use the sp_changemergearticle or the UI to set this column up.sql

No comments:

Post a Comment