Home Forums Article Discussions Article Discussions by Author Discuss content posted by Manish Mittal Finding rows count in a table without Select... RE: Finding rows count in a table without Select...

  • March 29, 2010 at 2:11 am

    #1141240

    DBCC UPDATEUSAGE - doesn't that only have to be run on SQL 2000 or upon upgrade from 2000 -> 2005?

    Actually that may provide the explanation. My original post was about inaccurate counts in a 2000 database I had migrated to 2008 and I didn't know about the caveat, so that may well be the answer.

    Thanks Jeff, Chris (and All)