Microsoft Distributed Transaction Coordinator (MS DTC) supports distributed updates in an application. This is the only way to guarantee tight consistency (all copies of your data always have the exact same data values at the exact same time) and that the data is in a state that would have been achieved had all the work been done at one site. SQL Server ships with the MSDTC service, which allows for this tight consistency, with real-time updates.