detect log file size

Hello,
Is there a SQL statement I can use to get the current size of a database's
log file?
Thanks,
DaveEXEC sp_helpfile '<database>_log'
--
Aaron Bertrand, SQL Server MVP
http://www.aspfaq.com/
Please reply in the newsgroups, but if you absolutely
must reply via e-mail, please take out the TRASH.
"David Reynolds" <david_m_reynolds@.hotmail.com> wrote in message
news:9JeQa.21491$lJd1.15720@.news01.bloor.is.net.cable.rogers.com...
> Hello,
> Is there a SQL statement I can use to get the current size of a database's
> log file?
> Thanks,
> Dave
>|||This is a good one too, it gives you the sizes and percentage used for
the log files.
dbcc sqlperf('logspace')
HTH
Ray Higdon MCSE, MCDBA, CCNA
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!sql