04 January 2013

Free Disk Space on SQL Server

We often are needed to develop command and control systems.
What happens if we need to develop a system that tell us about disk space SQL server
Here is the code
Select @@servername as 'SQL Server Name', getdate() as Date 
 EXEC master..xp_fixeddrives


Yours,
Roi