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?
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.