Post reply

System Table Differences

  • July 21, 2010 at 2:08 pm

    #227108

    Hello Everyone

    I am going thru all the code in an old SQL 2000 box, there are many DTS packages, functions and sprocs. There are many of these objects that query some of the system tables, such as sysobjects. That now, no longer exist in SQL 2008.

    What I am hoping to find, is a list of all the system table names from SQL 2000, that have been replaced by new System View names in SQL 2008. I am going to have to recode the Packages, and some of the sprcs and functions.

    Thanks

    Andrew SQLDBA

  • July 21, 2010 at 2:12 pm

    #1196481

    Search BOL for the phrase "Mapping System Tables to System Views". There's a whole chart there.

  • July 21, 2010 at 2:19 pm

    #1196489

    sysobjects exists in 2008, as does syscolumns and all the other familiar SQL 2000 objects. They're views, not tables, deprecated, included only for backward compatibility and will be removed in a future version, but they are there.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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