February 6, 2003 at 9:52 am
I encountered something interesting. I have a DTS package that updates a SQL Server 2000 table from a CSV file. The log file says it exported 206293 rows which is correct. However, when I look at the table properties it says that it only has 206131 rows. When I dump out the table with Query Analyzer it gives me 206293 rows. Could anybody explain why the Table Properties in Enterprise Manager always says 206131??
February 6, 2003 at 10:05 am
Update statistics for that table and check from EM again.
For examplr, UPDATE STATISTICS authors
Edited by - Allen_Cui on 02/06/2003 10:06:49 AM
February 6, 2003 at 10:24 am
I updated the statistics and it still says 206131..........
February 6, 2003 at 11:04 am
Run DBCC UPDATEUSAGE (databasename) should correct it. See BOL for more details.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply