Hi Expert, it is working amazingly and giving result as expected.

but the problem is, All the results should come as one output. this is the requirement for a...

Excellent.
this is the one which i've been using, but the requirement is to display for all databases. this query will give the result for the current database only.

Yes, this is what my requirement, but unable to keep that in the posted Query. i need help with that query to return percentages. please kindly modify accordingly and provide.

this error will come because of lack of paging memory in the selected drive.

ask your system engineer to check the paging drive memory. and ask him to chenge the drive...