SELECT top 1 rows FROM SYSINDEXES WHERE Id = OBJECT_ID('TableName')

its return the row count of the table which is same as select count(*) from table.