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 ‘%#%’

Leave a Reply