We are using sql 7.0 sp3, I have 2 linked servers and if at some point of the day (having probably 200 open connections) I try to compile or execute a stored procedure that has a link to that other server I get that error. If I wait until later during the day I'm able to compile. This is a big Compaq server 8000, with 2 gig of ram. I don't get it all the time, I have the memory allocation option automatic. Any clues ?