System Information in SQL Server 2000 vs SQL Server 2005

ID Information SQL Server 2000 SQL Server 2005 1 Database system table\view - Source for all databases on the SQL Server to include the name, owner, creation date, etc. SELECT * FROM master.dbo.sysdatabases GO SELECT * FROM sys.databases; GO 2 ...

www.mssqltips.com