temp table in sysobjects

Question

temp table in sysobjects

Viewing 6 posts - 31 through 35 (of 35 total)

You must be logged in to reply to this topic. Login to reply

DLathrop SSCrazy Points: 2018 More actions · Answer 1

jts_2003 (11/23/2010)
What interested me was how long the random names are in sysobjects - obviously Microsoft planning for LOTS of temporary objects being created!

It's not the number of names, it's to lower the chances of generating duplicate names. That's why GUID/UNIQUEIDENTIFIER values are so long.

David Lathrop
DBA
WA Dept of Health

archana.singh 38798 SSC Enthusiast Points: 126 More actions · Answer 2

This will surely work :

select * from sysobjects where name like '#testvm%'

nigel. SSChampion Points: 11636 More actions · Answer 3

archana.singh 38798 (11/23/2010)
This will surely work :
select * from sysobjects where name like '#testvm%'

No, because it will also return tables called '#testvm_something' etc. as was explained earlier

Nigel
How to post questions

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Thanks for the question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events