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.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Wrong Rows In Table Properties (SQL7)

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"
Go to Top of Page

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).


Go to Top of Page
   

- Advertisement -