How to find drive space using MS SQL SQL
This is one of the query I used to see in forums. I think people are not aware of the inbuilt stored procedure we have in SQL to get the drive space.
Below stored procedure will give drive space details of your hard disk. Just open the query analyser and execute it.
EXECUTE master..xp_fixeddrives
The out put will be,
drive MB free
C 42566
D 37566
Normally people use this value to send alert to the database admin if the free space is below the minimum level.
Follow
HI..
thanks for sharing such a good information.