Record Count of Tables in SQL Server

Also use either this one:
SELECT OBJECT_NAME(SYSINDEXES.id), SYSINDEXES.rowcnt
FROM SYSINDEXES INNER JOIN SYSOBJECTS ON SYSINDEXES.id = SYSOBJECTS.id
WHERE SYSINDEXES.indid < 2 AND SYSOBJECTS.xtype = 'U'


or this one:
SELECT OBJECT_NAME(id),rowcnt FROM SYSINDEXES WHERE OBJECTPROPERTY(id,'IsUserTable')=1 AND indid<2