earlier wins

From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 01/26/05 

Date: Wed, 26 Jan 2005 08:05:33 -0800

You have to add a datetime column :) This allows use of
Microsoft SQL Server DATETIME (Earlier Wins) Conflict
Resolver. However if the conflicts are only ever between
different subscribers, the default (local) priorities
will suffice - the first to subscribe will win.
Rgds,
  Paul Ibison SQL Server MVP, www.replicationanswers.com
  (recommended sql server 2000 replication book:
  http://www.nwsu.com/0974973602p.html)

Relevant Pages

  • Re: Turn OFF Automated Conflict Resolver in Merge Replication
    ... "Hilary Cotter" wrote: ... Looking for a SQL Server replication book? ... It is a joy to use the Conflict Resolver, ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL CE does not support download only ExchangeType ?
    ... Sometime ago I wanted to define a policy in conflict resolution 'server ... This resolver, and a few others, listed with the sp I told you are not ... >> SQL Server Download Only Conflict Resolver' ...
    (microsoft.public.sqlserver.ce)
  • Re: Auto Resolve Conflict
    ... There's a tab ... to use Local conflict management. ... "Microsoft SQL Server Subscriber Always Wins Conflict Resolver". ...
    (microsoft.public.sqlserver.replication)
  • Re: Conflict Viewer included with MSDE 2000 Release A?
    ... maintaining replication on SQL Server 2000 are part of Enterprise Manager ... > It seems that installing MSDE 2000 Release A does not install the conflict ... viewer, and therefore if a subscription is set to allow interactive conflict ... Replication are manually copied across and registered, ...
    (microsoft.public.sqlserver.msde)
  • Re: Me.Dirty - Where to put this logic?
    ... an Access frontend with SQL server backend. ... This is when the record is considered "dirty," it's there but not ... When the focus changes from the main form to a subform, ... data problem that is causing Access to *think* there's a write conflict ...
    (microsoft.public.access.forms)