Differenze
Queste sono le differenze tra la revisione selezionata e la versione attuale della pagina.
| Entrambe le parti precedenti la revisione Revisione precedente | Ultima revisioneEntrambe le parti successive la revisione | ||
| hobby:development:sql:select:sys_0003 [2023/08/30 11:46] – mauro.cortese | hobby:development:sql:select:sys_0003 [2023/11/13 21:04] – 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, |
| + | CASE db.compatibility_level | ||
| + | WHEN 65 THEN 'SQL Server 6.5 (65)' | ||
| + | WHEN 70 THEN 'SQL Server 7.0 (70)' | ||
| + | WHEN 80 THEN 'SQL Server 2000 (80)' | ||
| + | WHEN 90 THEN 'SQL Server 2005 (90)' | ||
| + | WHEN 100 THEN 'SQL Server 2008/R2 (100)' | ||
| + | WHEN 110 THEN 'SQL Server 2012 (110)' | ||
| + | WHEN 120 THEN 'SQL Server 2014 (120)' | ||
| + | WHEN 130 THEN 'SQL Server 2016 (130)' | ||
| + | WHEN 140 THEN 'SQL Server 2017 (140)' | ||
| + | WHEN 150 THEN 'SQL Server 2019 (150)' | ||
| + | WHEN 160 THEN 'SQL Server 2022 (160)' | ||
| + | ELSE 'new unknown - ' + CONVERT(varchar(10), | ||
| + | END CompatibilityLevel | ||
| 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 | + | |
| </ | </ | ||
mauro.cortese