IdentifyTranscation log name

Hi friends
I am trying to make a query to display dinamically the name of the
database's log.
I am trying with the sysfiles table (select * from sysfiles or sysfiles1),
but i cant get an unique column to identify what is the name of the log
can anyone help me?
Thanks in advance
Try,
select
fileid,
[name],
[filename]
from
sysfiles
where
fileproperty([name], 'IsLogFile') = 1
go
AMB
"Tinchos" wrote:

> Hi friends
> I am trying to make a query to display dinamically the name of the
> database's log.
> I am trying with the sysfiles table (select * from sysfiles or sysfiles1),
> but i cant get an unique column to identify what is the name of the log
> can anyone help me?
> Thanks in advance
>