DevPinoy.org
A Filipino Developers Community
   
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.


Posted 09-07-2007 11:30 AM by keithrull
Filed under: ,

Comments

Rohan Wali wrote re: How to: Get a list of fixed drives and their free space inside SQL Server
on 09-08-2007 6:53 AM

sweet!

lamia wrote re: How to: Get a list of fixed drives and their free space inside SQL Server
on 09-09-2007 11:09 PM

First thing I thought before reading your post was... Yeah, why would you need to know this inside an SQL script? But hell yeah, you might just need it someday! :)

bass_player wrote re: How to: Get a list of fixed drives and their free space inside SQL Server
on 09-13-2007 10:06 PM

There's more to it than that.  SQL Server has a bunch of "undocumented" stored procedures which come in handy every now and then.  Just remember, though, that there are what they are - undocumented.  Which means you cannot ask Microsoft for help when using these

Copyright DevPinoy 2005-2008