In SQL Server 2017,  you can use the new DMV sys.dm_os_enumerate_fixed_drives to identify free disk space. The DMV is replacement of xp_fixeddrives. Old way XP_FIXEDDRIVES New Way SELECT * FROM sys.dm_os_enumerate_fixed_drives; I wish Microsoft could have included the capacity of the drive. Not including the drive capacity requires the DBA to perform additional computations to […]