T-SQL to Get Drive Space Info

ProblemI was trying to get disk information like total space and free using t-sql but extended stored procedure xp_fixeddrives provides only free space info(see screen shot below).SolutionPowershell can fetch disk information very easily. T-SQL script below uses powershell to get

sp_spaceinfo.sql
 
 
 
 
 
(2)
716 times
Add to favorites
Databases
3/1/2012
E-mail Twitter del.icio.us Digg Facebook