Post reply

sys.objects

  • January 24, 2011 at 9:22 pm

    #230800

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

    M&M

  • January 25, 2011 at 1:03 am

    #1277644

    :w00t:

  • January 25, 2011 at 2:53 am

    #1277681

    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

  • January 25, 2011 at 3:02 am

    #1277684

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

  • January 25, 2011 at 3:11 am

    #1277693

    Thanks for the easy point today.

  • January 25, 2011 at 7:13 am

    #1277826

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

  • January 25, 2011 at 7:22 am

    #1277831

    Nice and easy start for the day..

  • January 25, 2011 at 7:26 am

    #1277832

    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.

  • January 25, 2011 at 7:54 am

    #1277857

    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.

    😎

  • January 25, 2011 at 8:41 am

    #1277910

    Thank you 🙂

    M&M

  • January 25, 2011 at 9:56 am

    #1277987

    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

  • January 25, 2011 at 10:02 am

    #1277990

    Thanks for an easy start to the day!

  • January 25, 2011 at 10:52 am

    #1278018

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

  • January 26, 2011 at 2:17 pm

    #1278788

    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

  • February 1, 2011 at 3:49 am

    #1280822

    Nice & Easy 😀

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

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