Database Information in SQL Server.

select @@servername as [Server], name as [Database Name],CAST(create_date as date) as [Created on], user_access_desc as [Access], state_desc as [State], recovery_model_desc as [Recover Model], page_verify_option_desc as [Page Verify] from sys.databases