Questa รจ una vecchia versione del documento!
Query Db User
(Elenca tutti i DB di un'istanza SQL Server)
SELECT
db.database_id ID,
db.name DBName,
mf.name LogicalName,
mf.type_desc FileType,
mf.Physical_Name Path,
mf.size Size,
db.collation_name Collation,
db.recovery_model_desc RecMode
FROM
sys.master_files mf
INNER JOIN
master.sys.databases db ON db.database_id = mf.database_id
WHERE db.database_id > 4
ORDER BY DBName, FileType
| ID | DBName | LogicalName | FileType | Path | Size | Collation | RecMode |
|---|---|---|---|---|---|---|---|
| 5 | Bom | Bom_log | LOG | P:\UserLog\LOG\Bom.ldf | 96 | Latin1_General_CI_AS | FULL |
| 5 | Bom | Bom_dat | ROWS | P:\UserDB\DATA\Bom.mdf | 88152 | Latin1_General_CI_AS | FULL |
| 6 | ErpLauncher | ErpLauncher_log | LOG | P:\UserLog\LOG\ErpLauncher.ldf | 3857 | Latin1_General_CI_AS | FULL |
| 6 | ErpLauncher | ErpLauncher_dat | ROWS | P:\UserDB\DATA\ErpLauncher.mdf | 112792 | Latin1_General_CI_AS | FULL |
| 7 | ErpTools | ErpTools_log | LOG | P:\UserLog\LOG\ErpTools.ldf | 640 | Latin1_General_CI_AS | FULL |
| 7 | ErpTools | ErpTools_dat | ROWS | P:\UserDB\DATA\ErpTools.mdf | 1280 | Latin1_General_CI_AS | FULL |
| 18 | Hrm | Hrm_log | LOG | P:\UserLog\LOG\Hrm.ldf | 776 | Latin1_General_CI_AS | FULL |
| 18 | Hrm | Hrm_dat | ROWS | P:\UserDB\DATA\Hrm.mdf | 1280 | Latin1_General_CI_AS | FULL |
| 8 | Ict | Ict_log | LOG | P:\UserLog\LOG\Ict.ldf | 3072 | Latin1_General_CI_AS | FULL |
| 8 | Ict | Ict | ROWS | P:\UserDB\DATA\Ict.mdf | 1024 | Latin1_General_CI_AS | FULL |
| 9 | LiveBom | LvtBom_log | LOG | P:\UserLog\LOG\LvtBom.ldf | 104 | SQL_Latin1_General_CP1_CI_AS | FULL |
| 9 | LiveBom | LvtBom | ROWS | P:\UserDB\DATA\LvtBom.mdf | 2584 | SQL_Latin1_General_CP1_CI_AS | FULL |
| 10 | LivePdm | LvtPdm_log | LOG | P:\UserLog\LOG\LvtPdm.ldf | 136 | SQL_Latin1_General_CP1_CI_AS | FULL |
| 10 | LivePdm | LvtPdm | ROWS | P:\UserDB\DATA\LvtPdm.mdf | 5960 | SQL_Latin1_General_CP1_CI_AS | FULL |
| 12 | LiveRights | LiveRights_log | LOG | P:\UserLog\LOG\LiveRights.ldf | 640 | Latin1_General_CI_AS | FULL |
| 12 | LiveRights | LiveRights_dat | ROWS | P:\UserDB\DATA\LiveRights.mdf | 1280 | Latin1_General_CI_AS | FULL |
| 13 | LiveSuite | LiveSuite_log | LOG | P:\UserLog\LOG\LiveSuite.ldf | 1024 | Latin1_General_CI_AS | FULL |
| 13 | LiveSuite | LiveSuite_dat | ROWS | P:\UserDB\DATA\LiveSuite.mdf | 7216 | Latin1_General_CI_AS | FULL |
| 14 | LiveSys | LiveSys_log | LOG | P:\UserLog\LOG\LiveSys.ldf | 640 | Latin1_General_CI_AS | FULL |
| 14 | LiveSys | LiveSys_dat | ROWS | P:\UserDB\DATA\LiveSys.mdf | 1280 | Latin1_General_CI_AS | FULL |
| 20 | LiveWatermark | LiveWatermark_log | LOG | P:\UserLog\LOG\LiveWatermark.ldf | 640 | Latin1_General_CI_AS | FULL |
| 20 | LiveWatermark | LiveWatermark_dat | ROWS | P:\UserDB\DATA\LiveWatermark.mdf | 1280 | Latin1_General_CI_AS | FULL |
| 17 | LvtPdmBase | LvtPdmBase_log | LOG | P:\UserLog\LOG\LvtPdmBase.ldf | 579072 | Latin1_General_CI_AS | FULL |
| 17 | LvtPdmBase | LvtPdmBase_dat | ROWS | P:\UserDB\DATA\LvtPdmBase.mdf | 251072 | Latin1_General_CI_AS | FULL |
| 16 | LvtPdmLibrary | Pdm_log | LOG | P:\UserLog\LOG\Pdm_Library.ldf | 114544 | Latin1_General_CI_AS | FULL |
| 16 | LvtPdmLibrary | Pdm_dat | ROWS | P:\UserDB\DATA\Pdm_Library.mdf | 251072 | Latin1_General_CI_AS | FULL |
| 11 | LvtPdmProd | Pdm_log | LOG | P:\UserLog\LOG\LvtPdmProd.ldf | 128 | Latin1_General_CI_AS | FULL |
| 11 | LvtPdmProd | Pdm_dat | ROWS | P:\UserDB\DATA\LvtPdmProd.mdf | 155112 | Latin1_General_CI_AS | FULL |
| 15 | Pdm | Pdm_log | LOG | P:\UserLog\LOG\Pdm.ldf | 128 | Latin1_General_CI_AS | FULL |
| 15 | Pdm | Pdm_dat | ROWS | P:\UserDB\DATA\Pdm.mdf | 193304 | Latin1_General_CI_AS | FULL |
| 24 | PdmGarbage | Pdm_log | LOG | P:\UserLog\LOG\PdmGarbage.ldf | 128 | Latin1_General_CI_AS | FULL |
| 24 | PdmGarbage | Pdm_dat | ROWS | P:\UserDB\DATA\PdmGarbage.mdf | 2416 | Latin1_General_CI_AS | FULL |
mauro.cortese