all data and log files

I am looking to find all my data and log files in my sql server. what is the
best way to find that out?
Thanks,What version are you using? Have a look at sys.database_files in
BooksOnLine.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
<omranu@.Gmail.com> wrote in message
news:O3OvDdL%23HHA.4880@.TK2MSFTNGP03.phx.gbl...
>I am looking to find all my data and log files in my sql server. what is
>the best way to find that out?
> Thanks,
>|||Try database properties.
<omranu@.Gmail.com> wrote in message
news:O3OvDdL%23HHA.4880@.TK2MSFTNGP03.phx.gbl...
>I am looking to find all my data and log files in my sql server. what is
>the best way to find that out?
> Thanks,
>|||select * from sys.sysaltfiles
In 2005 for backward compatibility as a view.
Ekrem Önsoy
<omranu@.Gmail.com> wrote in message
news:O3OvDdL%23HHA.4880@.TK2MSFTNGP03.phx.gbl...
>I am looking to find all my data and log files in my sql server. what is
>the best way to find that out?
> Thanks,
>|||In article <O3OvDdL#HHA.4880@.TK2MSFTNGP03.phx.gbl>, omranu@.Gmail.com
says...
> I am looking to find all my data and log files in my sql server. what is the
> best way to find that out?
> Thanks,
>
>
if you don't like T-SQL you should also be able to see them in SSMS or
Enterprise Manager depending on vn.
Graham (Pete) Berry
PeteBerry@.Caltech.edu