Carlo Romagnano (11/22/2010)
Also this is wrong:If you used a query like this, you would see your table:
You will see ALL tables that begins with '#testvm', also, tables belonging to other sessions.
... only if you are a privileged user on the server (a member of the sysadmin role, I assume). If you are an ordinary user, you can see only the temporary tables which have been created in your current connection.