Value of the Status column of SYS. sysdatabases

Status

BITs, some of which can be set by using alter Database
As noted:

1 =Autoclose
(Alter database)

4 =Select into/bulkcopy
(Alter database using set recovery)

8 =Trunc. Log On chkpt
(Alter database using set recovery)

16 =Torn page Detection
(Alter database)

32 =Loading

64 =Pre recovery

128 =Recovering

256 =Not recovered

512 =Offline
(Alter database)

1024 =Read Only
(Alter database)

2048 =DBO use only
(Alter database using set restricted_user)

4096 =Single User
(Alter database)

32768 =Emergency Mode

4194304 =Autoshrink
(Alter database)

1073741824 =Cleanly Shutdown

Multiple bits can be on at the same time.

 

 

Status2

16384 =ANSI null default
(Alter database)

65536 =Concat null yields null
(Alter database)

131072 =Recursive triggers
(Alter database)

1048576 =Default to local cursor
(Alter database)

8388608 =Quoted identifier
(Alter database)

33554432 =Cursor close on commit
(Alter database)

67108864 =ANSI nulls
(Alter database)

268435456 =ANSI warnings
(Alter database)

536870912 =Full text enabled
(Set by usingSp_fulltext_database
)