MS DTC is effective for an application that must update a database that has been partitioned for scalability. Consider a customer database that has been partitioned into a Northern Customers database and a Southern Customers database. Most business transactions only update a single database. However, if a customer from the Northern region does business in the Southern region, then both databases need to be updated. The application can use MS DTC to keep the databases consistent.
Updating a Database Partitioned for Scalability