Count All the row from All Table in a Database

SELECT

FROMsysobjects.Name, sysindexes.RowssysobjectsINNER JOIN sysindexesON sysobjects.id = sysindexes.idWHEREtype = 'U'
AND sysindexes.IndId < 2and sysindexes.Rows > 0ORDER BYsysobjects.Name