Home Forums Article Discussions Article Discussions by Author Discuss content posted by VM temp table in sysobjects RE: temp table in sysobjects
nigel.
SSChampion
Points: 11636
More actions
November 24, 2010 at 1:51 am
#1254931
archana.singh 38798 (11/23/2010)This will surely work : select * from sysobjects where name like '#testvm%'
archana.singh 38798 (11/23/2010)
select * from sysobjects where name like '#testvm%'
No, because it will also return tables called '#testvm_something' etc. as was explained earlier
NigelHow to post questions