Define Free Disk Space in SQL Server with TSQL Code

Define Free Disk Space in SQL Server with TSQL Code
 
This method is used to monitor free disk space usage. I am going to discuss a simple space observing method that uses an undocumented SQL Server extended stored procedure named xp_fixeddrives. This is available in SQL Server 2000 to 2008.