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