|
 |
About Us | |
|
SSWUG Articles | |
 |
Articles | |
|
FAQ |
|
Administration | |
|
Backup/Restore | |
|
Connectivity | |
 |
Development | |
|
General | |
|
Installation | |
|
OLAP | |
|
Replication | |
|
Transfer/move | |
|
Trouble | |
|
SQL 6.5 |
|
Scripts | |
|
Tips | |
|
Test Exams | |
|
Advertise | |
|
Download | |
|
History | |
|
Search | |
|
Traffic | |
|
Related Links | |
|
||
|
|
||
 How can I return from within a T-SQL the list of server's hard drives? Answer: You can use the xp_fixeddrives undocumented extended stored procedure to return the list of all hard drives and the amount of free space in Mb for each hard drive. This extended stored procedure does not require any parameters. This is the example to run: EXEC master..xp_fixeddrives See this article to get more information about the useful undocumented extended stored procedures: Useful undocumented extended stored procedures |