I have been wondering for some time what all the bits in the Status and
Status2 from the master..sysdatabases are. BOL only lists selected
bits, however I know that the additional bits are used because if I
bring up the status of a Database, I get the status 65536 which
according to BOL is not used (yeah right) so my question is what all
the missing bits? Even if the bit is used to report something mundane
it would be nice/fun to know.
Bit-01 status & 1 = Autoclose
Bit-02 status & 2 =
Bit-03 status & 4 = Select Into / Bulk Copy
Bit-04 status & 8 = Truncate Log on Checkpoint
Bit-05 status & 16 = Torn Page Detection
Bit-06 status & 32 = Loading
Bit-07 status & 64 = Pre-Recovery
Bit-08 status & 128 = Recovering
Bit-09 status & 256 = Not Recovered
Bit-10 status & 512 = Offline
Bit-11 status & 1024 = Read Only
Bit-12 status & 2048 = dbo USE Only
Bit-13 status & 4096 = Single User
Bit-14 status & 8192 =
Bit-15 status & 16384 =
Bit-16 status & 32768 = Emergency Mode
Bit-17 status & 65536 =
Bit-18 status & 131072 =
Bit-19 status & 262144 =
Bit-20 status & 524288 =
Bit-21 status & 1048576 =
Bit-22 status & 2097152 =
Bit-23 status & 4194304 = Autoshrink
Bit-24 status & 8388608 =
Bit-25 status & 16777216 =
Bit-26 status & 33554432 =
Bit-27 status & 67108864 =
Bit-28 status & 134217728 =
Bit-29 status & 268435456 =
Bit-30 status & 536870912 =
Bit-31 status & 1073741824 = Cleanly Shutdown
Bit-32
Bit-01 status2 & 1 =
Bit-02 status2 & 2 =
Bit-03 status2 & 4 =
Bit-04 status2 & 8 =
Bit-05 status2 & 16 =
Bit-06 status2 & 32 =
Bit-07 status2 & 64 =
Bit-08 status2 & 128 =
Bit-09 status2 & 256 =
Bit-10 status2 & 512 =
Bit-11 status2 & 1024 =
Bit-12 status2 & 2048 =
Bit-13 status2 & 4096 =
Bit-14 status2 & 8192 =
Bit-15 status2 & 16384 = ANSI NULL Default
Bit-16 status2 & 32768 =
Bit-17 status2 & 65536 = Concatenate NULL Yields NULL
Bit-18 status2 & 131072 = Recursive Triggers
Bit-19 status2 & 262144 =
Bit-20 status2 & 524288 =
Bit-21 status2 & 1048576 = Default to Local Cursor
Bit-22 status2 & 2097152 =
Bit-23 status2 & 4194304 =
Bit-24 status2 & 8388608 = Quoted Identifier
Bit-25 status2 & 16777216 =
Bit-26 status2 & 33554432 = Cursor CLOSE on Commit
Bit-27 status2 & 67108864 = ANSI NULLs
Bit-28 status2 & 134217728 =
Bit-29 status2 & 268435456 = ANSI Warnings
Bit-30 status2 & 536870912 = Full Text Enabled
Bit-31 status2 & 1073741824 =
Bit-32
|