How to identify SQL Server Database file location

If you want to know where exactly the database files or stored for each database using T-SQL. You can use the following query
This will work on Both SQL Server 2005 and Sql Server 2008


SELECT name AS [Database Name], physical_name AS [File Location]
FROM sys.master_files