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 free
C 5897
E 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.