:::: MENU ::::

Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views

  • Dec 04 / 2008
  • 0
dbDigger, Monitoring and Analysis, T-SQL Enhancements

Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views

As we know that system tables of SQL Server 2000 have been evolved to system views in SQL Server 2005. Although many system tables tables have been migrated to SQL Server 2005, but using the system view is more recommended because these will be preserved in coming versions of SQL Server. And also system views provided in SQL Server 2005 provide much more information about internals of SQL Server and meta data.
Visit following link to get mapping of SQL Server 2000 tables to SQL Server 2005 system views.

http://msdn.microsoft.com/en-us/library/ms187997(SQL.90).aspx

Consult us to explore the Databases. Contact us