Menü

sysdatabase status

Dekodiert die einzelnen Bits der Spalte „Status“ der Tabelle sysdatabases

Alle Angaben ohne Gewähr.
Detailierte Angaben finden Sie in der Online Dokumentation des SQL-Servers. Wenn Ihnen ein Fehler auffallen solte, melden Sie diesen bitte an support@eulanda.de.

sysdatabases-Spalten

Status: 0

BitBitsWertBeschreibung
 000000000000000000000000000000000Status
1-------------------------------01autoclose
3-----------------------------0--4select into/bulkcopy
4----------------------------0---8trunc. log on chkpt
5---------------------------0----16torn page detection
6--------------------------0-----32loading
7-------------------------0------64pre recovery
8------------------------0-------128recovering
9-----------------------0--------256not recovered
10----------------------0---------512offline
11---------------------0----------1024read only
12--------------------0-----------2048dbo use only
13-------------------0------------4096single user
16----------------0---------------32768emergency mode
23---------0----------------------4194304autoshrink
31-0------------------------------1073741824cleanly shutdown

Status2: 0

BitBitsWertBeschreibung
 000000000000000000000000000000000Status
15-----------------0--------------16384ANSI null default
17---------------0----------------65536concat null yields null
18--------------0-----------------131072recursive triggers
21-----------0--------------------1048576default to local cursor
24--------0-----------------------8388608quoted identifier
25-------0------------------------16777216(?) auto create statistics (undokumentiert)
26------0-------------------------33554432cursor close on commit
27-----0--------------------------67108864ANSI nulls
29---0----------------------------268435456ANSI warnings
30--0-----------------------------536870912full text enabled
31-0------------------------------1073741824(?) auto Update Statistics (undokumentiert)