Got it, Thank you !!

The output for sp_help sp_MSForEachDB is the following.

Msg 15009, Level 16, State 1, Procedure sp_help, Line 66

The object 'sp_MSForEachDB' does not exist in database 'master' or is invalid for this...

I tried this

SELECT '--Shows avail free DB space ' as ' '

exec sp_MSForEachDB 'Use ? SELECT name AS ''Name of File'', size/128.0 -CAST(FILEPROPERTY(name, ''SpaceUsed'' )

AS int)/128.0 AS ''Available...

Need some help...

The following gives an error.

SELECT '--Shows avail free DB space ' as ' '

exec sp_MSForEachDB 'Use ? SELECT name AS ''Name of File'', size/128.0 -CAST(FILEPROPERTY(name, ''SpaceUsed'' )

...

Yes, I have already tried that, but was looking for a OS level tool to retreive the error description. Let me know if you haev any idea on that...thank you.