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 7, 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: Wednesday, October 22, 2014 1:54 AM
Points: 1,174, Visits: 2,656
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 6:00 PM
Points: 17,825, Visits: 15,758
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
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 3, 2010 1:20 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:00 PM
Points: 2,160, Visits: 2,191
Thanks for the question, and the discussion.
Post #1030127
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse