Post reply

System Tables

  • June 24, 2008 at 7:59 am

    #192859

    Hi experts,

    Where can i find system tables like sysdatabases,sysprocesses etc.In 2000 am its there in master database .What about 2005???

    TIA

  • June 24, 2008 at 8:11 am

    #833331

    They are no system tables in SQl 2005, they are now DMV's

    Try, select * from sys.all_views or sp_help sysprocesses if you need definition of the columns.

    The sp_helptext wont work in 2005 as they are now system Views, so it is more trickier.

    Or look under Views--system Views

    Maninder
    www.dbanation.com

  • June 24, 2008 at 8:54 am

    #833362

    In a practical sense, Mani Singh is right. The Dynamic Management Views replace the system tables you're used to seeing in SQL 2000. In a strict sense, system tables do still exist - they're in the Resource database (see "Resource Database" in BOL).

    Greg

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

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