DISTRIBUTED TRANSACTION - errors and fixes

Open DISTRIBUTED TRANSACTION between servers

http://copypastenet.blogspot.co.il/2016/06/transaction-between-servers-distributed.html

OLE DB provider "SQLNCLI11" for linked server "" returned message "Cannot start more transactions on this session."

http://copypastenet.blogspot.co.il/2016/06/ole-db-provider-sqlncli11-for-linked.html

The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction.

http://copypastenet.blogspot.co.il/2016/06/the-microsoft-distributed-transaction.html