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

I need to select some data (surprise) from several tables in a linked database which is running SQL Server 2000.Now the resulting data set will be about 10,000 records taken from ~ 8 tables.I can ...

Replace "new_table" with the name of the table to create, and replace "old_table" with the name of the table to select from. The INTO clause behaves the same as CREATE TABLE in other SQL environments.