Problem Insert into from Linked Server SP.

Hi All , I am using SQL Server 2005 and trying to Insert the Data from Linked server SP but i am getting Error Like "Transaction context in use by another session." but the same is Working in SQL Server 2000.

Example Code :

create table #sSS

(

mmmm varchar(200)

)

Insert into #sSS (mmmm) Exec IC2.IC2.dbo.SSA

Msg 3910, Level 16, State 2, Line 1

Transaction context in use by another session.

Pls any one help me to solve this Issue

Regards

Sivaraman Latchapathi

Is this a loopback linked server? If so, it's a known, unsupported issue.
http://msdn2.microsoft.com/en-us/library/ms188716.aspx

The workaround is to split the insert/exec into 2 steps:
1. execute the remote stored procedure and insert the data into a #remote table
2. insert into #local select * from #remote