Also be careful if you inadvertently pass in an erroneous SQL string (i.e. refering to a field or table that doesn't exist). This may cause the server to ramp up...

... In the end I wrote a VB dll wrapper around the filesystemobject which seemed to work ok when call from the SP.

Richard

Thanks for the replies Steve.

I've tried xp_fixeddrives but it only gives free space. What I am after is the total size so I can give the percentage freespace as this...