Thanks! I wish there was some intrinsic value that you could ask and it would already be there......... sigh........ shows how much I know about it.........

Tommy

>There's another fast way but result isn't relaible because it's based on the data stored in sysindexes tables which may or may not be current.

SELECT rowcnt FROM sysindexes WHERE id=OBJECT_ID('dbo.mytable') and indid < 2

>
>
>>A friend of mine, here is trying to get a count of how many records are in a SQL table in MS-SQL.
>>
>>He tried SELECT COUNT(*) AS TOTRECS FROM MASTER_EVENT
>>
>>And it takes FOREVER to get a count because the record has around 12 Million Records.
>>
>>How to speed this up?????
>>
>>Thanks!!!!
>>
>>Tommy