Stored Procedure to return database size

• cytodex

  Old Hand

  Points: 337

  More actions

  October 25, 2002 at 2:18 pm

  #64610

  Is there any built-in st. proc to return the size of all databases in a SQL-Server 7. Thanks.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  October 25, 2002 at 2:46 pm

  #439521

  sp_helpdb

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

• cytodex

  Old Hand

  Points: 337

  More actions

  October 26, 2002 at 4:27 pm

  #439533

  Thanks for your reply. If I may ask one more question, how I can collect the max and used size of all databases ?

• Simon Sabin

  SSCrazy Eights

  Points: 8142

  More actions

  October 27, 2002 at 1:10 pm

  #439551

  This is a neat way of doing it

  sp_msforeachdb '?..sp_spaceused'

  Simon Sabin

  Co-author of SQL Server 2000 XML Distilled

  http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

  
  Simon Sabin
  SQL Server MVP
  
  http://sqlblogcasts.com/blogs/simons