sys.objects

Question

Post reply

sys.objects

M&M

SSC-Insane

Points: 21700
More actions
January 24, 2011 at 9:22 pm

#230800

Comments posted to this topic are about the item sys.objects
M&M

Viewing 15 posts - 1 through 15 (of 15 total)

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

Carlo Romagnano SSC-Insane Points: 22747 More actions · Answer 1

Carlo Romagnano

SSC-Insane

Points: 22747

January 25, 2011 at 1:03 am

#1277644

:w00t:

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 2

Nice and easy, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

cengland0 SSCertifiable Points: 6102 More actions · Answer 3

An easy question and I cannot believe I missed it. I answered too quickly without thinking about the other possibilities.

paul s-306273 SSChampion Points: 10730 More actions · Answer 4

paul s-306273

SSChampion

Points: 10730

January 25, 2011 at 3:11 am

#1277693

Thanks for the easy point today.

SanDroid SSChampion Points: 10068 More actions · Answer 5

Nice question. Obviously several people might learn something since "System base table" answer was almost as popular as the correct answer.

Surii Default port Points: 1497 More actions · Answer 6

Surii

Default port

Points: 1497

January 25, 2011 at 7:22 am

#1277831

Nice and easy start for the day..

cengland0 SSCertifiable Points: 6102 More actions · Answer 7

SanDroid (1/25/2011)
Nice question. Obviously several people might learn something since "System base table" answer was almost as popular as the correct answer.

Yup, that's the one I selected and as soon as I submitted my answer, I had a feeling it was going to be wrong.

SanDroid SSChampion Points: 10068 More actions · Answer 8

cengland0 (1/25/2011)
SanDroid (1/25/2011)
Nice question. Obviously several people might learn something since "System base table" answer was almost as popular as the correct answer.
Yup, that's the one I selected and as soon as I submitted my answer, I had a feeling it was going to be wrong.

Here is a quick of the history of sysobjects or sys.objects on the differant server versions.

SQL 2000 - dbo.sysobjects was a System table. Contains one row for each object (constraint, default, log, rule, stored procedure, and so on) created within a database. In tempdb only, this table includes a row for each temporary object. Some did call it the base system table since it was the first object listed.

http://msdn.microsoft.com/en-us/library/aa260447(SQL.80).aspx

SQL 2005 - sys.objects system view was created as part of the object catalog. dbo.sysobjects and sys.sysobjects are made as compatibility views. M$ recomends switching over from one to the other.

http://msdn.microsoft.com/en-us/library/ms177596(v=SQL.90).aspx

SQL 2008 - Nothing changes but the server version.

http://msdn.microsoft.com/en-us/library/ms177596(v=SQL.105).aspx

It is important to mention that not only do sysobjects and sys.objects have a differant name, they have a differant schema also. The column names are differant, along with some other things.

M&M SSC-Insane Points: 21700 More actions · Answer 9

M&M

SSC-Insane

Points: 21700

January 25, 2011 at 8:41 am

#1277910

Thank you

M&M

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

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

UMG Developer SSChampion Points: 13482 More actions · Answer 11

UMG Developer

SSChampion

Points: 13482

January 25, 2011 at 10:02 am

#1277990

Thanks for an easy start to the day!

Rose Bud Hall of Fame Points: 3147 More actions · Answer 12

I found SanDroid's history lesson very helpful. Thanks for adding it to the discussion.

TomThomson SSC Guru Points: 104773 More actions · Answer 13

Nice easy question.

But why have more than half the people who answered got it wrong? It is a straightforwards and easy one, isn't it? There's not something weird that's leading half the people to give wrong answers?

Tom

Dhruvesh Shah SSCrazy Points: 2303 More actions · Answer 14

Dhruvesh Shah

SSCrazy

Points: 2303

February 1, 2011 at 3:49 am

#1280822

Nice & Easy

sys.objects

Cookies on SQLServerCentral