xp_fixeddrives

Checking free disk space from T/SQL

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...