SQL Server 2000 used system tables to store meta-data about everything happening in the database. SQL Server 2005 doesn’t use system tables. The following table maps the new Views to the SQL Server 2000 system tables. You can query the views as you would any view, and you will find each database has a catalog of these views specific to that database.
Table B-1. Mapping of System Tables to SQL Server 2005
The following table lists the system tables in every SQL Server 2000 database and their corresponding system view or views in SQL Server 2005.
Table B-2. Mapping of SQL Server 2000 System Tables ...