Home Forums Article Discussions Article Discussions by Author Discuss content posted by VM temp table in sysobjects RE: temp table in sysobjects
Geoff A
SSChampion
Points: 11511
More actions
November 22, 2010 at 8:20 am
#1253780
So putting all this together we have:select * from tempdb.sys.objects where object_id = OBJECT_ID('tempdb.dbo.#testvm')Hope I've not missed anything 🙂
So putting all this together we have:
select * from tempdb.sys.objects where object_id = OBJECT_ID('tempdb.dbo.#testvm')
Hope I've not missed anything 🙂
seems perfect to me....