Since I went ahead and made the query which actually does provide the table and associated rowsize without cursors thought I would post it. (though I am sure Barry's does a LOT more ).

SELECT so.name 'Table', si.rows 'Rows'

FROM

(SELECT Name FROM sysobjects WHERE type='U') so

JOIN

(SELECT rows,id,indid FROM sysindexes) si

ON si.id = OBJECT_ID(so.name) AND si.indid < 2

Toni