Database Size

• AndrewSQLDBA

  SSC-Insane

  Points: 21827

  More actions

  August 5, 2010 at 1:09 pm

  #225802

  Hello Everyone

  Using SQL 2000 and 2005, I am looking for the table that stores the database size for all databases. For the life of me I cannot recall the name.

  It is not in the sysdatabases table. It would be nice if it were

  Thanks

  Andrew SQLDBA

• Tara Kizer

  SSCommitted

  Points: 1789

  More actions

  August 5, 2010 at 1:34 pm

  #1203099

  You can query sp_databases for that information.

  Tara Kizer
  Microsoft MVP for Windows Server System - SQL Server
  Ramblings of a DBA (My SQL Server Blog)[/url]
  Subscribe to my blog

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  August 5, 2010 at 1:40 pm

  #1203107

  You may be looking for:

  select * from master.dbo.sysaltfiles

  You can use the following script to get more detailed information:

  Get Server Database File Information

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058

• AndrewSQLDBA

  SSC-Insane

  Points: 21827

  More actions

  August 5, 2010 at 2:12 pm

  #1203125

  Thanks Greatly

  That is perfect

  Andrew SQLDBA