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

3.3 Star
973 times
Add to favorites
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.