Database properties …

--Database properties.

use
master go

select convert(varchar(500),'['+ltrim(rtrim(name))+']') as [Name], min(case
status & 8 when 8 then 'X' else 'O' end) as [trunc. log on chkpt], min(case
status & 4 when 4 then 'X' else 'O' end) as [select into/bulkcopy], min(case
status & 1 when 1 then 'X' else 'O' end) as [autoclose], min(case
status & 16 when 16 then 'X' else 'O' end) as [torn page detection], min(case
status & 32 when 32 then 'X' else 'O' end) as [loading], min(case
status & 64 when 64 then 'X' else 'O' end) as [pre recovery], min(case
status & 128 when 128 then 'X' else 'O' end) as [recovering], min(case
status & 256 when 256 then 'X' else 'O' end) as [Ot recovered], min(case
status & 512 when 512 then 'X' else 'O' end) as [offline], min(case
status & 1024 when 1024 then 'X' else 'O' end) as [read only], min(case
status & 2048 when 2048 then 'X' else 'O' end) as [dbo use only], min(case
status & 4096 when 4096 then 'X' else 'O' end) as [single user], min(case
status & 32768 when 32768 then 'X' else 'O' end) as [emergency mode], min(case
status & 4194304 when 4194304 then 'X' else 'O' end) as [autoshrink], min(case
status & 1073741824 when 1073741824 then 'X' else 'O' end) as [cleanly shutdown], min(case status2 & 16384 when 16384 then 'X' else 'O' end) as [ANSI null default], min(case status2 & 65536 when 65536 then 'X' else 'O' end) as [concat null yields null], min(case status2 & 131072 when 131072 then 'X' else 'O' end) as [recursive triggers], min(case status2 & 1048576 when 1048576 then 'X' else 'O' end) as [default to local cursor], min(case status2 & 8388608 when 8388608 then 'X' else
'O' end) as [quoted identifier], min(case status2 & 33554432 when 33554432 then 'X'
else 'O' end) as [cursor close on commit], min(case status2 & 67108864 when 67108864 then 'X' else 'O' end) as [ANSI nulls], min(case status2 & 268435456 when 268435456 then 'X' else 'O' end) as [ANSI warnings], min(case status2 & 536870912 when 6870912 then 'X' else 'O' end) as [full text enabled] from sysdatabases where name is not null group by name order by name