Many times we required to retrieve the information about hard drives and free space of drives of SQL Server that is remotely connected. As SQL Server is remotely so it may be possible that we don't have permission to access the OS. In such a case we use the system stored procedure to figure out the drives and free space available in drives.
Example:
Use following System stored procedure for this.
EXEC master..xp_fixeddrives