conflict resolution -- sql server replication

Ravi Lobo
4/3/2007 4:00:04 PM

I have a merge replication setup.
I am using column level tracking

Subscribers are CLIENTS, so they are at the same level

Initially values in table t1 as

C1 -> 1
C2 -> 2
C3 -> 3
C4 -> 4

Sub1 updates,
C1->11
C2->22

Sub2 updates,
C2->222 (CONFLICT)
C3->33

1. sub1 synchronizes
2. sub2 synchronizes
3. sub1 synchronizes

My final values are,
C1->11
C2->22
C3->3
C4->4

I am expecting
C1->11
C2->22
C3->33
C4->4

Can anyone put some light?

Hilary Cotter
4/4/2007 8:11:00 AM

What does the conflict viewer reveal?

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

sql server replication : conflict resolution