Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2002-05-30 : 08:50:45
|
Wu writes "When I Show Table Properties In Enterprise Manager, the Rows value is wrong ( just like which in table sysindexes). I try to correct it with DBCC UPDATEUSAGE, but it didn't work. Why?" |
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-05-30 : 23:05:54
|
seems to work in SQL 2000 OK.Why not just do select count(*) from TABLE?That'll work ALL the time--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-05-31 : 15:57:38
|
Does it happen for every table or for very large tables only(by "very large" I mean tables with more than 2.1 billion rows)? If you are seeing this behaviour with large tables only, you have probably exceeded the capacity of the [rows] field in sysindexes table(which is of datatype int). |
|
|
|
|
|