Yes how to do the above in a batch file. ie Could you give me an example please?

I've tried;

osql -E -Sservername -dmaster

exec sp_helpdb > 1.csv

This didn't work.

Hi David

Thank you very much for the info.

An example would be good as I am new to SQL programming.