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