Re: A conflict issue, or something else...?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 11/17/04 

Date: Wed, 17 Nov 2004 19:45:25 -0000

Tony,
'Treat changes to the same column as a conflict is selected' shouldn't make
any difference as it appears as though you don't have a conflict. However
you do have filters. If the record change violates the filter, it'll get
overwritten. If this is not the case I can't see how this is possible :)
Merge has no sense of the interim values - just the guid of the changes row
is of relevance, so the latest value at the time of running the merge agent
is used. Have you checked the conflict table just in case?
I'd guess it's either a filter issue or a conflict, although with your
selected resolver and one subscriber it's difficult to see.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
  (recommended sql server 2000 replication book:
   http://www.nwsu.com/0974973602p.html)

Relevant Pages

  • Re: compensate_for_errors property
    ... It was introduced in SQL Server 2000 ... remain on both the publisher and subscriber. ... and the row generated on the subscriber remaining. ... The conflict will still be logged and it is possible to roll it ...
    (microsoft.public.sqlserver.replication)
  • Re: Rows out of partition in merge replication
    ... Because if it is invalid at the subscriber it should be invalid at the ... publisher. ... which is not part of the filter statement, ... that if the conflict is not resolved manually by ...
    (microsoft.public.sqlserver.replication)
  • Insert at Subscriber using Queued Replication causes conflict
    ... subscriber and when the queue reader runs, ... conflict, but this is 'normal' replication behaviour (not ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Updates inhe publisher causes constraint violation in the subscrib
    ... I have a merge replication between a SQL server 2005 to a SQl server 2000 ... database. ... subscriber and I just dont seem to be able to find what the problem could be. ... This results in a conflict and I am unable to reslve / remove the conflict as ...
    (microsoft.public.sqlserver.replication)
  • Re: Origin of hoomu
    ... > Just add the other name to your filter. ... And thanks for not seeking a conflict. ... But more precisely, you were not disagreeing with me, ...
    (sci.lang.japan)