Database properties

Hi.

I am trying to look for ways on how to get all the databse properties under each instance.

say I want to view the size, recovery model, physical location, etc.

The sys.database_files is only applicable per database. Is there a query, or a table in master database to get these or store these values?

thanks...

You can query the sys.databases and sys.master_files to get this information on a per instance basis. You will need to query each instance seperatly.|||Thanks for that!