Determine available disk size with a sql query

Question

I need to determine the available space on the drive where my database lives. I know about the xp_fixeddrives procedure but how do I get the info for the specific drive where my database resides?

Answer 1

Hi, take a look at this link

http://blog.sqlauthority.com/2010/01/02/sql-server-find-location-of-data-file-using-t-sql/

Answer 2

You haven't mentioned your version of SQL Server. Starting with SQL Server 2005 you can get plenty of information from sys.database_files and relate that to the output of xp_fixeddrives.