OLE DB provider SQLNCLI for linked server returned message Cannot start more transactions on this session
OLE DB provider "SQLNCLI" for linked server returned message "Cannot start more transactions on this session."
Quick Fix: add below statement into your stored procedure who updates or transfer data on multiple server in transaction mode
SET XACT_ABORT ON
Here XACT_ABORT mode needs to be turned on