I didn't know that I could do this inside SQL Server
EXEC master..xp_fixeddrives
Executing the procedure onmy server gave me this result set:
drive MB freeC 5897E 33334
Man, I think it's about time I upgrade and brush up my SQL skills. I don't know why you would do it inside SQL Server. But then again it's pretty cool to know that something like this exist. You never know, you might need it someday.
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.