Bhuvnesh (1/26/2013)
why cant we use "xp_fixeddrive" ?
I suppose you could. I haven't used it since the SQL 2000 days and if what I am reading online is correct however it still does not report on mount points.
Personally I prefer to do this kind of work outside SQL Server, and have for quite a long time. With a single PowerShell script running on one my 'food court' database server I check available space on all the servers across my environment and store the results in a database. I could do alerting from there as well but I haven't had to. I try to leave that to monitoring tools like SCOM or SQLdm.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato