SELECT d.name, physical_name
FROM sys.master_files f join sys.sysdatabases d on f.database_id = d.dbid
where type_desc = 'ROWS'