Use the following to list the path for all MDF and LDF files of all databases on a SQL Server 2000 / 2005 / 2008

SELECT DB_NAME(dbid) AS databasename, fileid, name, filename FROM master.dbo.sysaltfiles