title: Best way to find free space in sql server databases?
body: <p>I want to be able to find out how much space is left in my database files so that I can know when to increase the space so it doesn't do it when the application is running hard out.</p>
  
  <p>I would prefer to be able to script this so I can run it across multiple databases ion a regular basis.</p>
  
  <p>I have SQL Server 2000 and SQL Server 2005 databases but I would prefer to be able to run the same script across both.   </p>
  
  <p>I can use Management Studio to do this manually on 2005 databases, but not on the 2000 databases.</p>