|
|
Posted by teddysnips on 06/29/07 14:28
I have a client who has reported a discrepancy in their database. In
their test database a certain report returns 5,333 rows, but in the
production database it returns 5, 332 rows.
I'll get to the bottom of it in due course, but I came across an
oddity. I wanted to know how many rows there were in a particular
table on both databases so I 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.
The thing is that the database is pretty static - in fact there's been
no activity (apart from me examining it) for a couple of days.
Thoughts?
Edward
Navigation:
[Reply to this message]
|