asked
select * from ##tablename
I am executing the below scrip " select * from ##tablename" getting error as :-Invalid object. How can i access this temporary table
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.
Check the existence of your global temp table using below query. SELECT * FROM tempdb..sysobjects where name like '%tablename%'
Better to use `SELECT OBJECT_ID('tempdb..[##myTempTableName]')`. You will receive the correct ID or NULL if table doesn't exists. The like can return multiple objects if you will search a local temp table, but also global with the same name exists or any other table with table name starting as your table exists.
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.
