list size of each database

• sqlstar2011

  SSCertifiable

  Points: 6000

  More actions

  May 11, 2006 at 11:05 am

  #114638

  is there anyway to get the size of each database in sql server instance in a list?

   

  thanks

• John Langston

  SSCommitted

  Points: 1977

  More actions

  May 11, 2006 at 11:26 am

  #637348

  How about sp_helpdb?

• Swaminathan-214060

  SSC Rookie

  Points: 27

  More actions

  May 12, 2006 at 7:38 pm

  #637706

  Hi Buddy,

  use sp_Msforeachdb stored procedure with your optional query to fetch the db size.