CREATE TABLE #LOGSPACE
(
 DB SYSNAME,
 LogSize FLOAT,
 SpaceUsed FLOAT,
 Stat BIT
);

INSERT  INTO #LOGSPACE
        (
         DB,
         LogSize,
         SpaceUsed,
         Stat
        )
        EXEC (
              'DBCC SQLPERF (LOGSPACE)'
            );

SELECT  DB,
        LogSize,
        SpaceUsed,
        LogSize * (SpaceUsed / 100.0) AS SpaceUsedMB, -- approximate log backup size
        Stat
FROM    #LOGSPACE;

CREATE TABLE #LOGSPACE
(
 DB SYSNAME,
 LogSize FLOAT,
 SpaceUsed FLOAT,
 Stat BIT
);

INSERT  INTO #LOGSPACE
        (
         DB,
         LogSize,
         SpaceUsed,
         Stat
        )
        EXEC (
              'DBCC SQLPERF (LOGSPACE)'
            );

SELECT  DB,
        LogSize,
        SpaceUsed,
        LogSize * (SpaceUsed / 100.0) AS SpaceUsedMB, -- approximate log backup size
        Stat
FROM    #LOGSPACE;

Use yourdb
GO
Select name, size / 128,
fileproperty(name, 'spaceused') / 128
From sys.database_files
Where type = 1 -- tlog files only