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
 
 
 
 
 
3.3 Star
(3)
973 times
Add to favorites
Databases
3/1/2012
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • Can the drive output name be added to the volume?
    1 Posts | Last post October 26, 2012
    • Great script there. What would be cool is to have the volume name for the drive added to the output also.
  • No question. Just complements.
    1 Posts | Last post October 12, 2012
    • Great script! Saved me a bunch of work in the future.