No transaction is active message when accessing Linked Server

(Pradeep Adiga) Last week I had worked on an issue related to Linked Server. The customer had migrated the SQL Server Instances to Virtual Servers. They had quite a few Linked Servers setup. After migration any Distributed Transaction like the one below across the linked servers would fail immediate

Read More - Register for Free Membership