Thanks for the replys,
Satya I followed your instructions and can confirm msdtc is fully enabled on both servers.
Netic there is a windows...
I Checked for the MSDTC in both the server it is enabled and running
MSDTC is running on both the server
Here what is selected:
Network DTC Access (Checked)
Allow Remote Client (Checked)
No working same error is comming
OLE DB provider "SQLNCLI" for linked server "SERVERNAMESQLEXPRESS" returned message "No transaction is active.".
I m trying to get record from one server to another using Commit and Rollback feature in the Sql Server and getiing error message--
Separate names with a comma.