Error uncountered :
The operation could not be performed because OLE DB provider “SQLNCLI11” for linked server “bms” was unable to begin a distributed transaction
Solution :
In the linked server settings, set the value below to False.
Resolve OLE DB provider “SQLNCLI11” with SQL Linked Server