How to repair table row count of 0

[jpm3]

Has anyone seen a table row count property go to 0? (Enterprise manager, right-click on a table, and choose properties).

It is some kind of damage that occurs, causing queries to ignore indexes and use table scans. We haven't found any information on this - let alone how to repair it!

Replies are greatly appreciated!!

 

[NoCoolHandle]

What hapens if you query the table?

Have you tried update statistics?
or
dbcc updateusage with count_rows

Rob

 

[jpm3]

Thanks Rob, this worked:

dbcc updateusage (database, tablename) with count_rows