Kevin Wilkie explains what distributed transactions are and why you probably don’t want to use them:
In the version of transactions that we going to discuss today, we’re going to discuss doing transactions on multiple servers!
A Distributed transaction is defined by HazelSet to be “a set of operations on data that is performed across two or more data repositories”. In even simpler terms, it’s a command run against data on more than one server.
Click through for the warnings about what might possibly go wrong.