Hi Erland Sir,

Thanks for revert. We are looking for a solution wherein records at locations A, B and C are fully in sync with each other; if not in real time; say after lag of 15 or 20 minutes atleast. 

Say location 'A' will insert a record which location 'B' and location 'C' will edit. For example location A (Head quarter) inserts a tentative despatch plan for say tomorrow in which location B (warehouse) has to despatch say 1000 qty and location C (warehouse) 2000 qty; however due to some unavoidable/valid reasons location B can despatch say only 800 qty and location C can despatch say 1900 qty of same item; then this information will be updated by location B and C at their warehouse locations. First location B and then location C update their final despatch capacity for tomorrow. After say last update of location 'C'; same data is to be available at all 3 locations i.e. all 3 locations should see that B can despatch only 800 against original requirement of 1000 and C can despatch only 1900 against 2000. There shouldn't be data loss i.e. say after 'last' edit is done by location 'C' at 10.15 am and data user at location 'A' and location B (say location B has edited his record at 9.55 am) looks at data say at 10.35 am he/she should be able to see that B can despatch only 800 and C can despatch only 1900; for better co-ordination within 3 teams; with customers and re-alignment. Database will be at all 3 locations and management intends to use technology from Sql Server ecosystem to keep all 3 locations data in full sync however not replication. Please suggest. Or is there some option outside of Sql Server which keeps data fully in sync. Thanks in advance.