SQL Server Performance Forum – Threads Archive

No: of drives in a server- from QA

How to find no: of drives nd drives names from QA . any sp_ or xp_ procedure for that?

---

exec xp_fixeddrives Dbu

---

hi dbu, SQL BOL doesnt shows any information about xp_fixeddrives…Why?

---

It’s one of many undocumented stored procedures:
http://www.sql-server-performance.com/ac_extended_stored_procedures.asp

---

Just for a Note. But these are undocumented. These things can be changed in future.

---

]]>