O'Reilly logo

SQL Server 2005 Distilled by Eric L. Brown

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix B. System Tables and View in SQL Server 2005

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

image

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required