Those who have been working with SQL Server administration for a while now undoubtedly have at times refered to the old SQL Server system tables in order to automate some processes, or document their tables by for example combining the sysobjects and syscolumns tables. As per SQL Server 2005 and onwards, Microsoft added a number of Dynamic Management Views (DMV) that take simplify all kinds of management tasks.
This article will give a list of SQL Server 2000 system tables and their 2005 equivalent management views, as well as a brief description what kind of information to find in the views.
Dynamic Management Views existing in the Master database
This article will give a list of SQL Server 2000 system tables and their 2005 equivalent management views, as well as a brief description what kind of information to find in the views.
Dynamic Management Views existing in the Master database
SQL Server 2000 | SQL Server2005 | Description | sysaltfiles | sys.master_files | Contains a row per file of a database as stored in the master database. |
---|---|---|---|---|---|
syscacheobjects | sys.dm_exec_cached_plans | Returns a row for each query plan that is cached by SQL Server for faster query execution. |