replication conflict when use BEGIN TRANSACTION COMMIT TRANSACTION

replication conflict when use BEGIN TRANSACTION COMMIT TRANSACTION

Post by rl » Wed, 20 Jul 2005 21:55:57


Ok let me explain my problem

I update table abc to SERVER A
SERVER A push a replication to SERVER B
and SERVER B push to SERVER A and SERVER C

SERVER A and C are configure to replicate to SERVER B and
SERVER B is configure to replicate to SERVER A and SERVER C
(same tables are replicate)

I have no problem while I not use BEGIN TRANSACTION UPDATE... COMMIT
TRANSACTION

When I use BEGIN TRANSACTION UPDATE... COMMIT TRANSACTION I got a conflict
error
 
 
 

replication conflict when use BEGIN TRANSACTION COMMIT TRANSACTION

Post by rl » Wed, 20 Jul 2005 23:03:31

supp info:
2 Queued update conflict. Subscriber wins. Updating Publisher ...