get Transaction Log size SQL Server 2008

Here is quick way to get Transaction Log size

DBCC SQLPERF(LOGSPACE)

Generate Row number

This method will only work when you do "select into from "

Syntax is :
select identity(int,1,1) as RowNumber, *
into newtable
from oldtable