I’ve seen some very creative ways to see how much free disk space SQL Servers have. Most make use of xp_cmdshell which some very complex dos commands or vbscripts.
However there is a much easier way. Microsoft has included the system extended stored procedure xp_fixeddrives. It returns the all the fixed drives and the amount of free space in megs.
DennyContact the Author | Contact DCAC