THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Database Develo... » T-SQL Snack   (RSS)
Sorry, but there are no more tags available to filter with.
  • T-SQL Snack: How Much Free Storage Space is Available?

    Introduction Ever have a need to calculate the total available storage space for a server? Recently I did. Here's a solution I came up with - I bet someone can do this better! xp_fixeddrives There's a handy stored procedure called xp_fixeddrives that reports the available storage space: exec xp_fixeddrives This returns: drive MB free----- ...
    Posted to Andy Leonard (Weblog) by andyleonard on May 27, 2010
Privacy Statement