It sounds like you want to check the sys.database_files catalog view, such
as:
SELECT name, physical_name FROM sys.database_files

--
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.

[quoted text, click to view]

how can i find out by Transact-SQL the path to a certain db data file
(mdf)?