Issue with Execute Store Procedure distributed transaction

Certified Senior Developer

Hi All,

We are facing an issue with execute store procedure.

 The stored procedure involves an OPENQUERY statement that connects to another server's database table and inserts data into it. Previously, we were using the deprecated Execute Stored Procedure method without any issues. As part of our version upgrade, we have updated with Execute Stored Procedure (Native) method, which is not functioning as expected.

Please find the sample query in the stored procedure - INSERT OPENQUERY (<linkedServerName>, 'Select <columns from linked server DB Table>') SELECT <columns from current DB Table>;

Error Message:  The operation could not be performed due to the OLE DB provider "MSOLEDBSQL" for linked server "dxbkdb01_edms" being unable to begin a distributed transaction.

Error Message

Thanks for your guidance in advance!!

  Discussion posts and replies are publicly visible