• use databasename

    go

    select * from sys.sysfiles

    go

    select * from sys.database_files

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)