MSDTC - Microsoft Distributed Transaction Coordinator should be installed (Service up and running) when executing the BEGIN DISTRIBUTED TRANSACTION statement that controls the completion of the transaction. So to complete this transaction with a subsequent COMMIT TRANSACTION or ROLLBACK TRANSACTION statement is issued for the session, the controlling instance requests that MS DTC manage the completion of the distributed transaction across all of the instances involved. By experience I can say unless...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/tools/archive/2007/10/11/sql-server-msdtc-do-you-need-it-or-not.aspx