• You can
    exec tempdb.dbo.sp_help '#temp'
    and you have all details about #temp

    Igor Micev,My blog: www.igormicev.com