Drive letters and MDF/LDF files...

All,
I'm writing to ask if anyone knows whether or not MS SQL server stores in any system tables the association between a database and the drive letter/directory path where its corresponding MDF/LDF files are located.
Thanks,
IsaacSELECT database_id
, name
, physical_name
FROM sys.master_files

SQL 2005 - not sure re 2000|||select filename
from master..sysaltfiles|||Exec master.dbo.sp_helpfile

Regards,

hmscott|||SELECT name
, physical_name
FROM [dbName].sys.database_files