Below you will find the code to return several database settings for each database. Simply select the text and copy to the Clipboard.
SELECT CONVERT(VARCHAR(100),Name) AS ‘Name’
, recovery_model_desc
, page_verify_option_desc
, user_access_desc
, is_read_only
, collation_name
FROM sys.databases
This code was written using the Microsoft SQL Server documentation. If you find that this code was copied from else where, please let me know so I can give proper credit.