>I am new to SQL server replication and planning to set up merge replication among 3 SQL servers at 3 different sites. If 2 users modify the same record at same time in of 2 different site, will the change in one site overwrites that of other site without warning?
>
>(This message was posted onto the SQL Server Forum and got no reply. Maybe, the experts in this forum can help.)
>
>KM
KM,
It depends.
When you set up replication, you have the option of assigning a synchronizarion priority. If none is set then the changes get assigned the priority of the publisher machine. If both machines in question, get assigned the same priority (either explicitly by you or automatically in the case above) then the first machine's changes will take effect. If you set different priorities then the changes from the machine with the highest priority will win.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao