Listing SQL Database File Locations

CREATE TABLE #Files (
[DatabaseName] sysname NOT NULL,
[name] [nchar] (128) NOT NULL,
[physical_name] [nchar] (260) NOT NULL
)
EXEC sp_msforeachdb 'Use [?] 
INSERT #Files 
SELECT "?", name, physical_name FROM sys.database_files'

SELECT * FROM #Files
ORDER BY #Files.DatabaseName

DROP TABLE #Files