• Nice Question .

    There is a another way to Check that , using the below query

    create table #testvm (ID int)

    select * from tempdb.sys.objects where OBJECT_id= object_id('tempDB..#testvm')

    drop table #testvm

    Thanks & Regards

    Deepak.A