When i double click on my table in enterprise manager, it shows 35367 rows. But when i do a count(*), it returns 35527! I did a commit to confirm that there's no uncommitted transaction but it's still the same.. anyone knows what should be the correct number of rows in the table? and what can i do to solve this inconsistency error?
EM uses the data from sysindexes system table to get its rowcount. But if you query sysindexes before the table's statistics are updated, you will get this inconsistency. Update statistics to better ensure consistency in this regard. Using SELECT COUNT(*) will always be more accurate (but will be slower).