Q:

how to find out log size of each of the database in sql server 2005?

Duplicate of: How to find out size of the individual databases in the sql server 2005?
how to find out log size of each of the database in sql server 2005?

A:

You can use this SQL:
EXECUTE sp_msforeachdb 'SELECT *, GETDATE() FROM [?].sys.database_files'

