https://msdn.microsoft.com/ko-kr/library/ms179900.aspx
select @@servername
select
name, case when status & 1 = 1 then 'autoclose' else null end
,case when status & 4 = 4 then 'select into/bulkcopy' else null end
,case when status & 8 = 8 then 'trunc. log on chkpt' else null end
,case when status & 16 = 16 then 'torn page detection' else null end
,case when status & 32 = 32 then 'loading 복원중' else null end
,case when status & 64 = 64 then 'pre recovery' else null end
,case when status & 128 = 128 then 'recovering' else null end
,case when status & 256 = 256 then 'not recovered' else null end
,case when status & 512 = 512 then 'offline' else null end
,case when status & 1024 = 1024 then 'read only' else null end
,case when status & 2048 = 2048 then 'dbo use only' else null end
,case when status & 4096 = 4096 then 'single user' else null end
,case when status & 32768 = 32768 then 'emergency mode' else null end
,case when status & 65536 = 65536 then 'CHECKSUM' else null end
,case when status & 4194304 = 4194304 then 'autoshrink' else null end
,case when status & 1073741824 = 1073741824 then 'cleanly shutdown' else null end
from master.dbo.sysdatabases