September 13, 2010 at 8:52 am
Hi,
Is there a SQL Server script that gives information about a hard drive, like the size of the Hard Drive, Free space and how much of the hard drive is used?
September 13, 2010 at 9:38 am
You can't get this from T-SQL. You would have to call some Windows functions to get this, and you can shell out somehow to get those from T-SQL, but it's not recommended.
Here are a few articles that can help you:
http://qa.sqlservercentral.com/articles/1114/
http://qa.sqlservercentral.com/articles/1415/
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
September 13, 2010 at 9:47 am
Thanks Steve for the info...
Why is it not recommended? What would be the issue?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply