I've an SQL Server on my main site with a local Program that works with it and everything works fine.
My second site in in another country and because of a latency problems i want to set up another SQL server in my second site and replicate between them. the problem is that both site needs to work on the same tables.
i fear the if the connection between the two sites will be down and both sites will update the same table and then the connection will be up again and it won't be able to replicate anymore because both servers has data in the same table in the same line but it will be different..
any idea what to do?