SELECT DB_NAME(database_id) AS DatabaseName, Name AS Logical_Name, Physical_Name, (size*8)/1024 SizeMB FROM sys.master_files where Physical_name like '%.mdf' and DB_NAME(database_id) not in ('master','tempdb','model','msdb','ReportServer','ReportServerTempDB')
ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.