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 ...

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 ...

By using the nomenclature #localtable or ##globaltable SQL Server knows to create a table in TempDB. If you use a local temp table, it is only available for your current session.

Flat File Import into SQL Server Now that you’ve automated the fetching of your flat file via FTP, the next step is to automatically import that file into SQL Server.