Click here to Skip to main content
13,596,893 members
Click here to Skip to main content
Add your own
alternative version


2 bookmarked
Posted 19 Mar 2012
Licenced CPOL

Finding available free space in the disks of SQL Server

, 19 Mar 2012
Rate this:
Please Sign up or sign in to vote.
Simple query to find the available hard disk space in the server


As part of regular maintanence we needed to send a weekly report that included available harddisk space in our PROD SQL Server. This required a remote desktop login to the restrictive PROD environment and checking the space. We were unable to automate the status checks due to this particular item, after months of doing this as a manual activity found out that a simple procedure call will return the hard disk space from the Server machine.

Using the code

Just run the below procedure, no input parameters required!!


Output would be like this

drive MB free
----- -----------
C     31450
D     450047


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Saral S Stalin
Technical Lead
India India
No Biography provided

You may also be interested in...


Comments and Discussions

-- There are no messages in this forum --
Permalink | Advertise | Privacy | Cookies | Terms of Use | Mobile
Web02-2016 | 2.8.180621.3 | Last Updated 19 Mar 2012
Article Copyright 2012 by Saral S Stalin
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid