1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| SELECT name,
CASE status
WHEN 1 THEN 'AUTO_CLOSE'
WHEN 4 THEN 'SELECT INTO/BULKCOPY'
WHEN 8 THEN 'CHECKPOINT'
WHEN 16 THEN 'TORN PAGE DETECTION'
WHEN 24 THEN 'TRUNC. LOG ON CHKPT + TORN PAGE DETECTION'
WHEN 28 THEN 'SELECT INTO/BULKCOPY + TRUNC. LOG ON CHKPT + TORN PAGE DETECTION'
WHEN 32 THEN 'LOADING'
WHEN 64 THEN 'PRE-RECOVERY'
WHEN 128 THEN 'RECOVERING'
WHEN 256 THEN 'NOT RECOVERED'
WHEN 320 THEN 'NOT RECOVERED + PRE RECOVERY = SUSPECT'
WHEN 512 THEN 'OFFLINE'
WHEN 528 THEN 'OFFLINE + TORN PAGE DETECTION'
WHEN 1024 THEN 'READ_ONLY'
WHEN 2048 THEN 'dbo USE ONLY'
WHEN 4096 THEN 'SINGLE_USER'
WHEN 32768 THEN 'EMERGENCY'
WHEN 262144 THEN 'MISSING FILES'
WHEN 4194304 THEN 'AUTO_SHRINK'
WHEN 4194328 THEN 'AUTO_SHRINK + TRUNC. LOG ON CHKPT + TORN PAGE DETECTION'
WHEN 16777216 THEN 'AUTO_CREATE_STATISTICS'
WHEN 1073741824 THEN 'CLEANLY SHUTDOWN'
WHEN 1090519040 THEN 'AUTO_UPDATE_STATISTICS + AUTO_CREATE_STATISTICS'
WHEN 1073741840 THEN 'CLEANLY SHUTDOWN + TORN PAGE DETECTION'
END etat
FROM master.dbo.sysdatabases
WHERE name NOT IN ('master', 'msdb', 'model','distribution', 'ReportServer', 'ReportServerTempDB', 'pubs') |
Partager