How to know No.of records exists in all the Tables in Particular Database?

SELECT SysObj.name [Table Name],MAX(SysInd.rows)[Rows]
FROM SYSOBJECTS SysObj INNER JOIN SYSINDEXES SysInd ON
SysObj.id = SysInd.id WHERE xtype = 'U'
AND OBJECTPROPERTY(SysObj.id,'IsUserTable')= 1
GROUP BY SysObj.name ORDER BY Rows DESC