Row Count Discrepancy

When I run the following statement
Select count(*) from table_x
I get row count value of 391 rows.

When I use SQL Enterprise Manager and right click on the table and select properties, I see a rowcount of 463.

I ran dbcc checkdb, newallow, checktable, sp_updatestats, checkcatalog.

Still show the row count discrepancy exists.

SQL2000 SP4, Windows2003 SP1

Anyone see this before? Thanks, BPH

Run DBCC UPDATEUSAGE and try again

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" -- http://sqlservercode.blogspot.com/

Good Effort. Didn't solve the issue. I'm stumped.

How many records do you see when execute the following:

SELECT * FROM table_x

Do you get 391 or 463?

are you doing count(*) or count(field)

look at this difference

CREATE TABLE testnulls (ID INT)
INSERT INTO testnulls VALUES (1)
INSERT INTO testnulls VALUES (2)
INSERT INTO testnulls VALUES (null)


SELECT COUNT(*) FROM testnulls --3
SELECT count(id) FROM testnulls --2



“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" -- http://sqlservercode.blogspot.com/

I'm using select count(*) from tablex and get 391.

463 comes from properties in SQL EM

I exported the data to a test table, and then the properties and the select coutn(*) are the same at 391.

Wierd.

Your table is correct, and you can try to save it by using DBCC DBREINDEX (Indexes may be messed up). Other than that, I think it's a goner.

Sorry, I meant to say "Your original table is corrupt"...

You're probably right. thanks for the help everyone.