sys.objects

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 Mohammed Moinudheen... » sys.objects

16 posts, Page 1 of 2

1 2 »»

sys.objects

Rate Topic

Display Mode

Topic Options

Author

Message

mohammed moinudheen

Posted Monday, January 24, 2011 9:22 PM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:29 PM
Points: 2,178, Visits: 3,599

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

Mohammed Moinudheen

Post #1052840

Carlo Romagnano

Posted Tuesday, January 25, 2011 1:03 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 1,996, Visits: 1,864

Post #1052905

Koen Verbeeck

Posted Tuesday, January 25, 2011 2:53 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:30 AM
Points: 9,410, Visits: 6,495

Nice and easy, thanks.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1052954

cengland0

Posted Tuesday, January 25, 2011 3:02 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354, Visits: 1,299

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

Post #1052957

paul s-306273

Posted Tuesday, January 25, 2011 3:11 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 9:12 AM
Points: 1,167, Visits: 646

Thanks for the easy point today.

Post #1052966

SanDroid

Posted Tuesday, January 25, 2011 7:13 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232, Visits: 1,046

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

Post #1053126

Surii

Posted Tuesday, January 25, 2011 7:22 AM

SSChasing Mays

Group: General Forum Members
Last Login: Thursday, June 13, 2013 10:57 AM
Points: 659, Visits: 465

Nice and easy start for the day..

Post #1053131

cengland0

Posted Tuesday, January 25, 2011 7:26 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354, Visits: 1,299

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. Cool

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.

Post #1053132

SanDroid

Posted Tuesday, January 25, 2011 7:54 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232, Visits: 1,046

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. Cool

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.
Cool

Post #1053162

mohammed moinudheen

Posted Tuesday, January 25, 2011 8:41 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:29 PM
Points: 2,178, Visits: 3,599

Thank you

Mohammed Moinudheen

Post #1053227

« Prev Topic | Next Topic »

16 posts, Page 1 of 2

1 2 »»

Permissions