--===================Show Disk Drive free space in MB
DECLARE @DriveInfo TABLE (drive char(1),freeMB bigint)
INSERT INTO @DriveInfo exec xp_fixeddrives
SELECT 
	drive
	,Round(CAST((freeMB/1024.00) as float),2) as [GB free] 
	,IsLow = CASE WHEN Round(CAST((freeMB/1024.00) as float),2) < 10 THEN 'Yes' ELSE Null END
FROM 
	@DriveInfo
ORDER BY 
	[GB free]
	,drive