How to check SQL Server Database available(free) s

• mohamedriyaz

  SSC Journeyman

  Points: 78

  More actions

  August 17, 2003 at 12:27 am

  #59091

  Dear all,

  How to find out sql server database available(free) size using Query analyzer?. Since I don't have permission to use Enterprise Manager,I tried with stored procedure sp_helpdb <dbname>, that only gives used space.

  plz provide me solution using Query analyzer.

  regards

  riyaz

• mccork

  SSC-Insane

  Points: 22288

  More actions

  August 17, 2003 at 12:53 am

  #470204

  Try:

  use <dbname>

  exec sp_spaceused

  Cheers,

  - Mark

  
  Cheers,
  - Mark