Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to repair table row count of 0

Status
Not open for further replies.
jpm3

jpm3

IS-IT--Management
Apr 28, 2003
17
US
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!!
 
Sort by date Sort by votes
What hapens if you query the table?

Have you tried update statistics?
or
dbcc updateusage with count_rows

Rob
 
Upvote 0 Downvote
Thanks Rob, this worked:

dbcc updateusage (database, tablename) with count_rows

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Question
Group results into one row 3
2
Replies
37
Views
895
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
577
BobSuruncle
BobSuruncle
SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
591
SashaBuilder3
SashaBuilder3
peac3
  • Locked
  • Question
Consolidate multiple rows into single row 1
Replies
4
Views
678
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
915
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top