Error message when you run a distributed query against a loopback linked server in SQL Server 2005: ‘Transaction context in use by another session’

When you run a distributed query against a loopback linked server in Microsoft SQL Server 2005, you receive various error messages. Usually, you receive one of the following error messages: Error message 1 Msg 3910, Level 16, State 2, Line 1 Transaction context in use by another session. Err

Read More - Register for Free Membership