• In SQL 2005 and 2008 use

    Select * from sys.database_files

    Select * from sys.master_files