Differenze
Queste sono le differenze tra la revisione selezionata e la versione attuale della pagina.
Entrambe le parti precedenti la revisione Revisione precedente Prossima revisione | Revisione precedente | ||
hobby:development:sql:select:sys_0003 [2023/08/30 11:46] – mauro.cortese | hobby:development:sql:select:sys_0003 [2023/11/13 21:07] (versione attuale) – mauro.cortese | ||
---|---|---|---|
Linea 8: | Linea 8: | ||
db.database_id ID, | db.database_id ID, | ||
db.name DBName, | db.name DBName, | ||
- | mf.name LogicalName, | + | |
mf.type_desc FileType, | mf.type_desc FileType, | ||
mf.Physical_Name Path, | mf.Physical_Name Path, | ||
- | mf.size Size, | + | |
- | db.collation_name Collation, | + | db.collation_name Collation, |
- | db.recovery_model_desc RecMode | + | db.recovery_model_desc RecMode, |
+ | CompatibilityLevel = CASE db.compatibility_level | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | END | ||
FROM | FROM | ||
sys.master_files mf | sys.master_files mf | ||
Linea 19: | Linea 33: | ||
master.sys.databases db ON db.database_id = mf.database_id | master.sys.databases db ON db.database_id = mf.database_id | ||
WHERE db.database_id > 4 | WHERE db.database_id > 4 | ||
- | ORDER BY DBName, FileType | + | |
+ | |||
</ | </ | ||