A double # table is a global temporary table, and will cease to exists when all connections have stopped referencing it and the session that created the table has ended.
If you try to access the table outside of these conditions, it will no longer exist.
answered Nov 28, 2011 at 02:45 AM
Kev Riley ♦♦
Check the existence of your global temp table using below query. SELECT * FROM tempdb..sysobjects where name like '%tablename%'
answered Dec 10, 2011 at 01:27 AM
i think there are two table, one is local temp table which we create like #table and another is ##Table which is global temp table concept.
local will be accesible to you only while ## global to all user who are on server till the time session not end by creator.
answered Dec 13, 2011 at 03:35 AM