sys.databases

One of those views where nearly every column is useful to look at. Many of the settings configured through ALTER DATABASE are viewable here.

 

Formatted query for sys.databases

select
   d.name,
   d.database_id,
   --d.source_database_id,
   d.owner_sid,
   d.create_date,
   d.compatibility_level,
   d.collation_name,
   --d.user_access,
   d.user_access_desc,
   d.is_read_only,
   d.is_auto_close_on,
   d.is_auto_shrink_on,
   d.state,
   d.state_desc,
   d.is_in_standby,
   d.is_cleanly_shutdown,
   d.is_supplemental_logging_enabled,
   --d.snapshot_isolation_state,
   d.snapshot_isolation_state_desc,
   d.is_read_committed_snapshot_on,
   --d.recovery_model,
   d.recovery_model_desc,
   --d.page_verify_option,
   d.page_verify_option_desc,
   d.is_auto_create_stats_on,
   d.is_auto_update_stats_on,
   d.is_auto_update_stats_async_on,
   d.is_ansi_null_default_on,
   d.is_ansi_nulls_on,
   d.is_ansi_padding_on,
   d.is_ansi_warnings_on,
   d.is_arithabort_on,
   d.is_concat_null_yields_null_on,
   d.is_numeric_roundabort_on,
   d.is_quoted_identifier_on,
   d.is_recursive_triggers_on,
   d.is_cursor_close_on_commit_on,
   d.is_local_cursor_default,
   d.is_fulltext_enabled,
   d.is_trustworthy_on,
   d.is_db_chaining_on,
   d.is_parameterization_forced,
   d.is_master_key_encrypted_by_server,
   d.is_published,
   d.is_subscribed,
   d.is_merge_published,
   d.is_distributor,
   d.is_sync_with_backup,
   d.service_broker_guid,
   d.is_broker_enabled,
   --d.log_reuse_wait,
   d.log_reuse_wait_desc,
   d.is_date_correlation_on
from
   sys.databases d
| Copyright 2007-2020 RMJCS