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

Then they're there, no one knows it, and you can use the full functionality of Access.<BR><BR>When you're done, you might do a benchmark between using the temp table versus sql server to see if it ...

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. If you create a ...