Select Max([rows]) as [RowCount], sysobjects.name From
sysIndexes Left Join Sysobjects
On  sysindexes.id = sysobjects.id
Where sysobjects.xtype = 'U' and sysobjects.name != 'sysdiagrams'
Group by sysobjects.name