how get data and log file names for each database

Using SS2000. I'm trying to list the data and log files for each database. I found the data filename in sysdatabases but where is the log filename?
Thanks,
Dan D.
how about this?
SELECT * FROM sysfiles
Keith
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:033064C1-068D-4124-8105-0621EDA42B5C@.microsoft.com...
> Using SS2000. I'm trying to list the data and log files for each database.
I found the data filename in sysdatabases but where is the log filename?
> Thanks,
> --
> Dan D.
|||I was hoping for something that I could use and not have to go to each database. But I can write a script to loop through all of the databases.
Thanks,
Dan D.
"Keith Kratochvil" wrote:

> how about this?
> SELECT * FROM sysfiles
> --
> Keith
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:033064C1-068D-4124-8105-0621EDA42B5C@.microsoft.com...
> I found the data filename in sysdatabases but where is the log filename?
>
|||How about select * from sysaltfiles
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:9E6DAB1D-1D6A-4D06-A01E-B27DF7045541@.microsoft.com...
> I was hoping for something that I could use and not have to go to each
database. But I can write a script to loop through all of the databases.[vbcol=seagreen]
> Thanks,
> --
> Dan D.
>
> "Keith Kratochvil" wrote:
database.[vbcol=seagreen]
|||Easy enough:
EXEC sp_Msforeachdb
'USE ?;
SELECT * FROM sysfiles;'
Keith
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:9E6DAB1D-1D6A-4D06-A01E-B27DF7045541@.microsoft.com...
> I was hoping for something that I could use and not have to go to each
database. But I can write a script to loop through all of the databases.[vbcol=seagreen]
> Thanks,
> --
> Dan D.
>
> "Keith Kratochvil" wrote:
database.[vbcol=seagreen]
|||That works. Didn't know about that table. Thanks.
Dan D.
"Jasper Smith" wrote:

> How about select * from sysaltfiles
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:9E6DAB1D-1D6A-4D06-A01E-B27DF7045541@.microsoft.com...
> database. But I can write a script to loop through all of the databases.
> database.
>
>
|||That's good. I've never used that sp before. Thanks.
Dan D.
"Keith Kratochvil" wrote:

> Easy enough:
>
> EXEC sp_Msforeachdb
> 'USE ?;
> SELECT * FROM sysfiles;'
> --
> Keith
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:9E6DAB1D-1D6A-4D06-A01E-B27DF7045541@.microsoft.com...
> database. But I can write a script to loop through all of the databases.
> database.
>
|||Good suggestion! I forgot about that table. The beauty of this method: one
set of results.
Keith
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eQNg$VpaEHA.3664@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> How about select * from sysaltfiles
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:9E6DAB1D-1D6A-4D06-A01E-B27DF7045541@.microsoft.com...
> database. But I can write a script to loop through all of the databases.
> database.
filename?
>