Microsoft SQL Server 2005 Best Practices
The following extended stored proc returns the free disk space available on server fixed disk drives:
exec master.dbo.xp_fixeddrives