Find all databases and physical path on SQL Server

Here's a very simple way to find all databases and their physical path on the server:

SELECT [name], [physical_name],[Size]FROM sys.master_files

Happy Coding...