U can Use below sql query to count the record from any user table

select rows

from sys.sysindexes

where id = object_id('Table_Name')

and indid < 2