Local temporary tables are available to the current connection for the user, so they disappear when the user disconnects. Global temporary tables may be created with double hashes (##).

Local temporary tables are visible only in the current session; global temporary tables are visible to all sessions.<BR><BR>Prefix local temporary table names with single number sign (#table_name ...

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