I need to select some data (surprise) from several tables in a linked database which is running SQL Server 2000 ... then store them in a temp table. That way (I assume) I won't have to waste ...

I was thrilled to learn that SQL Server 2008 offers this functionality. Here are instructions on how to pass table variables (and the data in them) into stored procedures and functions.

I tried this in the past, but didn't have any luck.<BR><BR>Is it possible to create a temp table on a remote server?<BR><BR>Situation:<BR><BR>I have to run a group of queries against a remote server.