>I have a large number of databases, and I need to check on the Data files - File name - location Transaction files - file name and location Recover methord on all the databases Is there a way of doing this other that viewing the Properties screen of each database

Use the sp_helpdb stored procedure. If you just execute "sp_helpdb" it will give you info on all the databases, if you pass it a database name "sp_helpdb 'northwind'" it will also give you the file alocation properties for that database.

See the BOL for more info.

Cheers,
Eric Stephani