Kaufmännische Software für Handel, Handwerk und Produktionsbetriebe
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.
Status: 0
| Bit | Bits | Wert | Beschreibung |
|---|---|---|---|
| 00000000000000000000000000000000 | 0 | Status | |
| 1 | -------------------------------0 | 1 | autoclose |
| 3 | -----------------------------0-- | 4 | select into/bulkcopy |
| 4 | ----------------------------0--- | 8 | trunc. log on chkpt |
| 5 | ---------------------------0---- | 16 | torn page detection |
| 6 | --------------------------0----- | 32 | loading |
| 7 | -------------------------0------ | 64 | pre recovery |
| 8 | ------------------------0------- | 128 | recovering |
| 9 | -----------------------0-------- | 256 | not recovered |
| 10 | ----------------------0--------- | 512 | offline |
| 11 | ---------------------0---------- | 1024 | read only |
| 12 | --------------------0----------- | 2048 | dbo use only |
| 13 | -------------------0------------ | 4096 | single user |
| 16 | ----------------0--------------- | 32768 | emergency mode |
| 23 | ---------0---------------------- | 4194304 | autoshrink |
| 31 | -0------------------------------ | 1073741824 | cleanly shutdown |
Status2: 0
| Bit | Bits | Wert | Beschreibung |
|---|---|---|---|
| 00000000000000000000000000000000 | 0 | Status | |
| 15 | -----------------0-------------- | 16384 | ANSI null default |
| 17 | ---------------0---------------- | 65536 | concat null yields null |
| 18 | --------------0----------------- | 131072 | recursive triggers |
| 21 | -----------0-------------------- | 1048576 | default to local cursor |
| 24 | --------0----------------------- | 8388608 | quoted identifier |
| 25 | -------0------------------------ | 16777216 | (?) auto create statistics (undokumentiert) |
| 26 | ------0------------------------- | 33554432 | cursor close on commit |
| 27 | -----0-------------------------- | 67108864 | ANSI nulls |
| 29 | ---0---------------------------- | 268435456 | ANSI warnings |
| 30 | --0----------------------------- | 536870912 | full text enabled |
| 31 | -0------------------------------ | 1073741824 | (?) auto Update Statistics (undokumentiert) |