Also check out SQL-DMO. It's an object model that wraps all of the system stored procedures. It's also covered in the BOL.

-Mike


>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