Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Nicholas Williams,
This script will provide information on the drive capacities, in the form of total volume, used space, free space and then a percentage of used space.
Assuming that it is being executed on Windows Server 2003+ and the user calling it has permissions to run xp_cmdshell it should run without a problem
The script uses a built in tool present in Windows Server 2003 onwards, however this utility can be downloaded and deployed on other Windows Server operating systems. (Such as Windows Server 2000)
Hope you guys find it usefull!
I got new drives for my Windows Home Server the other day and decided to add some space to the...
Check Free Disk Space for Multiple SQL Servers.
MSDTC in Windows 2008 server
why aren't spaces counted?
Combine Drive Space report for all Servers