temp table in sysobjects

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by VM » temp table in sysobjects

36 posts, Page 4 of 4

«««1 2 3 4

temp table in sysobjects

Rate Topic

Display Mode

Topic Options

Author

Message

DLathrop

Posted Tuesday, November 23, 2010 7:02 PM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 10:43 AM
Points: 84, Visits: 202

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

archana.singh 38798

Posted Tuesday, November 23, 2010 11:52 PM

Forum 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

nigel.

Posted Wednesday, November 24, 2010 1:51 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 7:31 AM
Points: 1,164, Visits: 2,601

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

SQLRNNR

Posted Wednesday, November 24, 2010 10:55 AM

SSCoach

Group: General Forum Members
Last Login: Today @ 10:25 AM
Points: 18,754, Visits: 12,337

Thanks for the question.

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

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

archana.singh 38798

Posted Wednesday, November 24, 2010 9:13 PM

Forum Newbie

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

Well said Nigel. Smile

Post #1026310

UMG Developer

Posted Friday, December 03, 2010 1:20 PM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 11:21 AM
Points: 2,163, Visits: 2,148

Thanks for the question, and the discussion.

Post #1030127

« Prev Topic | Next Topic »

36 posts, Page 4 of 4

«««1 2 3 4

Permissions