row count
 

I am using rowcnt column in sysindexes to report some database statistics.
I used the "max" to get a valid row count (as I found multiple records for many tables) for each table, and added status<>0 in the conditions to get valid results.
All went OK except for some rare cases where empty tables seem to have "old" row count still stuck in the column !!
must I update database statistics using dbcc something !? or is there an additional condition for selecting from sysindexes !?

thanks,

Re: row count
 

I think you should use count() .