Physical Database and Log File location

Question

How do I get the Physical Database and Log File location (file system path) of a DB in SQL Server 2005?

I used this to get the mdf file: {SELECT [Name], FileName FROM sysdatabases} but need to get the log file as well...

Cheers, Conor

Answer 1

SELECT * FROM sys.database_files

Answer 2

Here is another way

select * from sys.sysaltfiles