A question about the use of the MemToLeave memory space. Will a series of linked server (insert statements with varibales provding values not table joins) calls made from a single stored proc execution progressivly use memory from the MemToLeave area or will each call de-allocate its usage when finished. If memory isn't de-allocated then I will only be able to do so many inserts before the memory space fills within a single proc call. I'm trying to determine if it is more efficient to have a single call inserting into the remote table based on a fetch from a local table or a series of insert statements in the form insert into linkedserver.db.dbo.table values (@v1,@v2) where the variables are supplied by a cursor looping through the local table. This is a SQL server 2000 to SQL server 2000 linked server - Same collation. I know the OLD DB provider gets loaded into memory for a linked server call but I'm not sure about the cumulative use of memory whith multiple calls from a single running process. Any help appreciated. Rick.