How to: Get a list of fixed drives and their free space inside SQL Server

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.

Leave a Reply