Query All SQL 2008 Database File locations

I am using the following code to list all the DBs file location.
select CHAR(13) + 'use [' + name + ']' + CHAR(13) + CHAR(13) + 
' select physical_name from sys.database_files' + CHAR(13) 
+ 'GO' from sys.databases

Advertisement