Alternative way instead of SELECT COUNT(*) statement.

SELECT rows FROM sysindexes WHERE id = OBJECT_ID('RD_AlertsHistory') AND indid < 2