sys.objects

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

    M&M

  • :w00t:

  • 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

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

  • Thanks for the easy point today.

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

  • Nice and easy start for the day..

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

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

    😎

  • Thank you 🙂

    M&M

  • 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

  • Thanks for an easy start to the day!

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

  • 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

  • Nice & Easy 😀

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

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