List of Temp Tables in your SQL server
select create_date,modify_date,OBJECT_NAME(object_id) as TableName
from tempdb.sys.objects
where name like ‘%#%’
select create_date,modify_date,OBJECT_NAME(object_id) as TableName
from tempdb.sys.objects
where name like ‘%#%’
My Twitter Feed