How much free space is available from T-SQL

Often, before doing large operations, I need to find the free disk space.
Microsoft SQL Server provides xp_fixeddrives to display the list of all the hard drives and their free space.

Applies to:

EXEC xp_fixeddrives;
go

drive MB free
----- -----------
C     2694

xp_fixeddrives will list all the drives.
xp_fixeddrives will return not the size of the drives, but the free space in megabytes/MB.
xp_fixeddrives is not documented in the books-on-line, therefore is not supported by Microsoft. I hope that it will still be available in Microsoft SQL Server 2008.

SQLHacks for Microsoft SQL Server
Home page Administration Dates & Times Data Manipulation FAQs Optimization Summaries Site Map About us About us Copyrights Credits Disclaimers Guaranties Privacy Support policies Feedback	Administration How much free space is available from T-SQL How much free space is available from T-SQL Often, before doing large operations, I need to find the free disk space. Microsoft SQL Server provides xp_fixeddrives to display the list of all the hard drives and their free space. Applies to: Microsoft SQL Server 2000 Microsoft SQL Server 2005 Free space EXEC xp_fixeddrives; go drive MB free ----- ----------- C 2694 xp_fixeddrives will list all the drives. xp_fixeddrives will return not the size of the drives, but the free space in megabytes/MB. xp_fixeddrives is not documented in the books-on-line, therefore is not supported by Microsoft. I hope that it will still be available in Microsoft SQL Server 2008.
All contents in SQLHacks.com are the property of db Networks Ltd and it's affiliates. All other trademarks not owned by db Networks Ltd or its affiliates that appear on the SQLHacks.com site are the property of their respective owners, especially: Windows^Ž, MS SQL^Ž, SQL Server^Ž which are the property of Microsoft Corp. DB2^Ž which is the property of IBM Systems. Oracle database^Ž which is the property of Oracle Corp.