Hi
I am running a distributed query after establishing a link with a remote server and encounter the following error message.

Server: Msg 3910, Level 16, State 1, Line 2 Transaction context in use by another session.

I dynamically build the query by writing the SELECT statement into a variable and execute the same using EXEC(). The first EXEC() successfully executes but the second query generates the above error. Searched MSDN for this error and it says that this error is supposed to occur only in a Loop-back server environment. Actually my query is not running in a loop-back server environment. Any ideas?