select substring(o.name, 1, 30) Table_Name ,i.rows Number_of_Rows from sysobjects o inner join sysindexes i on (o.id = i.id) where o.xtype = 'u' and i.indid < 2 order by o.name
select substring(o.name, 1, 30) Table_Name ,i.rows Number_of_Rows from sysobjects o inner join sysindexes i on (o.id = i.id) where o.xtype = 'u' and i.indid < 2 order by o.name