Home Forums Article Discussions Article Discussions by Author Discuss content posted by VM temp table in sysobjects RE: temp table in sysobjects
deepak.a
SSCertifiable
Points: 5330
More actions
November 22, 2010 at 12:17 am
#1253594
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