how to find used and freespace in each database in an instance of sql 2005 server

• amit kumar trripathy

  SSC Journeyman

  Points: 78

  More actions

  February 28, 2008 at 8:31 pm

  #187138

  Hi,

  Instead of pulling reports for each database in sql server 2005 is there any way(using command) for finding out used and free space for all the databases in an instance of sql server 2005.

  Regards

  Amit.

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  February 28, 2008 at 8:48 pm

  #783577

  Get Server Database File Information

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

• amit kumar trripathy

  SSC Journeyman

  Points: 78

  More actions

  March 2, 2008 at 9:59 pm

  #784292

  Its working!!:)

  Thank you.

• StormNorm

  SSCommitted

  Points: 1654

  More actions

  March 4, 2008 at 6:48 pm

  #785272

  See my script and RS report here which will display all the information for all databases on a server in one report.