title: Physical Database and Log File location
body: <p>How do I get the Physical Database and Log File location (file system path) of a DB in SQL Server 2005?</p>
  
  <p>I used this to get the mdf file: {SELECT [Name], FileName FROM sysdatabases} but need to get the log file as well...</p>
  
  <p>Cheers,
  Conor</p>