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

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer ...

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