SQL Server prevent Table Spool

[Ranthalion]

Hi,

I have a query that inserts records from one table into another table on a linked server. The problem is that it takes close to 30 seconds to perform the query. If I just insert the records into a table on the same server instead, the query completes almost instantly. I am fairly certain that I am not dealing with a network speed problem.

I looked at the execution plan and found that the insert query that inserts the remote server includes a Table Spool/Eager Spool that the other query does not contain. This step has Cost: 83%, so that's where my time is going.

How can I prevent the Table Spool/Eager Spool? I've looked for query hints, but can't seem to find what I'm looking for. Also, I'm using SQL Server 2000.

Here is an example of my query:

Insert Into RemoteServer.Database.Owner.Table
    (field1,field2,field3,field4,field5)
Select field1,field2,field3,field4,field5
From Table

Thanks,
Ranthalion