Inadvertently Promoting a Local Transaction to a Distributed Transaction

I recently dealt with a customer issue where they were troubleshooting MSDTC, and upon hearing the explanation of exactly what they were doing, I was a bit surprised that a distributed transaction was being used. Upon further investigation, they were unintentionally promoting a local transaction to a distributed transaction.  The reason behind this that they…