Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

temp table in sysobjects Expand / Collapse
Author
Message
Posted Tuesday, November 23, 2010 7:02 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, April 07, 2014 6:15 PM
Points: 86, Visits: 216
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
Post #1025614
Posted Tuesday, November 23, 2010 11:52 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 13, 2012 11:44 AM
Points: 2, Visits: 4
This will surely work :

select * from sysobjects where name like '#testvm%'
Post #1025677
Posted Wednesday, November 24, 2010 1:51 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:26 AM
Points: 1,174, Visits: 2,637
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
Useful Links:
How to post data/code on a forum to get the best help
The "Numbers" or "Tally" Table - Jeff Moden

Post #1025713
Posted Wednesday, November 24, 2010 10:55 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 5:28 PM
Points: 20,483, Visits: 14,136
Thanks for the question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1026058
Posted Wednesday, November 24, 2010 9:13 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 13, 2012 11:44 AM
Points: 2, Visits: 4
Well said Nigel.
Post #1026310
Posted Friday, December 03, 2010 1:20 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 8:50 AM
Points: 2,163, Visits: 2,184
Thanks for the question, and the discussion.
Post #1030127
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse