Post reply

difference in system views / tables

  • March 3, 2009 at 1:50 am

    #155359

    what's the conceptual difference between sys.sysobjects, sys.objects and sysobjects (in sql server 2005)? (or other name resembling tables / views)

    i can see there are different columns, but why need 3 different views (tables)?

    thanks

  • March 3, 2009 at 3:20 am

    #952289

    the sysobjects view is used for backward compatibility for 2000. the sys.objects is the new 2005 view.

  • March 3, 2009 at 3:40 am

    #952301

    In SQL Server 2000 system meta data was stored in tables. e.g. sysobjects. In SQL Server 2005 meta data is now provided through views like sys.objects. For sake of compatibility SQL Server 2000 meta data tables are also present in later versions. Views provide better security for SQL Server meta data in 2005 and 2008 versions.

    DBDigger Microsoft Data Platform Consultancy.

  • March 4, 2009 at 6:51 am

    #953116

    got it, thanks a lot guys

Viewing 4 posts - 1 through 3 (of 3 total)

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