Log file sizes
select size as 'pages', size*8000 as 'size', name from sysfiles
For the whole database
sp_spaceused @updateusage = 'TRUE'
For a specific table
sp_spaceused @objname = '<table_name>'
Log file sizes
select size as 'pages', size*8000 as 'size', name from sysfiles
For the whole database
sp_spaceused @updateusage = 'TRUE'
For a specific table
sp_spaceused @objname = '<table_name>'