Posted by Roy Harvey on 06/29/07 14:42

On Fri, 29 Jun 2007 07:28:03 -0700, teddysnips@hotmail.com wrote:

>SELECT COUNT(*) AS NumRows FROM Answer
>
>It returned 1,919,456. However, if I click on the Answer table in
>Enterprise Manager and select Properties it tells me that there are
>1,919,421 rows. I've tried doing a refresh but it didn't work.

Those statistics are not always accurate. To fix them run

DBCC UPDATEUSAGE(0) WITH COUNT_ROWS

Roy Harvey
Beacon Falls, CT

• Next in forum: Connecting to SQL 2005 using VB6
• Prev in forum: Mismatch between Count(*) and Properties -> Rows
• Thread view: Re: Mismatch between Count(*) and Properties -> Rows

[Reply to this message]