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

 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

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Comments