Sql Server procedure xp_fixeddrives
- Posted by Sqltimes
- On November 10, 2012
- 0 Comments
Today, we will look at one of the obscure built-in procedures in Sql Server. There is not much documentation that I could find on this, except a couple of other blog posts. May be for a good reason, but here it is.
[sourcecode language=”sql”]
EXEC xp_fixeddrives
GO
[/sourcecode]
Gives you the free space available on all the drives attached to the machine on which Sql Server instance is running.
Result:
xp_fixedDrives
Hope this helps,
0 Comments