查詢數(shù)據(jù)庫列表及文件位置
SELECT d.name, physical_name FROM sys.master_files f join sys.sysdatabases d on f.database_id = d.dbid where type_desc = 'ROWS'
SELECT d.name, physical_name FROM sys.master_files f join sys.sysdatabases d on f.database_id = d.dbid where type_desc = 'ROWS'