This will get the maximum possible rowsize for the employees table in the pubs database:
select sum(sc.length)
from sysobjects so
join syscolumns sc on so.id = sc.id
where so.name = 'employee'
and so.xtype = 'U'
This is not the maximum actual row length, but the maximum possible (i.e. every varchar column is maxed out in the row).