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 using sp_fulltext_database
)