Is database backup compression enabled?

How do I check if database compression is already enabled?


select case when value = 1 then 'Yes' else 'No' end as [Backup Compression Enabled] from sys.configurations where name = 'backup compression default' ;

Are remote admin connections enabled?

How do I check if remote admin connections are enabled?

select case when value = 1 then 'Yes' else 'No' end as [Remote Admin Connections Enabled] from sys.configurations where name = 'remote admin connections' ;

Check if database mail is enabled

How do I check if database mail is enabled?

select case when value = 1 then 'Yes' else 'No' end as [Database Mail Enabled] from sys.configurations where name = 'Database Mail XPs' ;