[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 252
  • Last Modified:

equivalent of sys.databases in SQL 2k

What is the system table equivalent to SQL 2005's sys.databases, where you can see a snapshot of all the database details.

thanks
0
anushahanna
Asked:
anushahanna
2 Solutions
 
RiteshShahCommented:
SELECT *
FROM master.dbo.sysdatabases
GO
0
 
Anoo S PillaiCommented:
SELECT *
FROM master.dbo.sysdatabases  
You will get a detailed view of database files and file sizes using sysaltfiles, See the sample script below.

SELECT DB_NAME(DBID) AS DB_Name,Size*8/1024 AS SizeOnDiskMB,*
FROM MASTER..SYSALTFILES

 
0
 
anushahannaAuthor Commented:
Thanks for both the tables.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now