Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006

    Unanswered: Discrepancy on Number of Rows

    Hi There,

    Good Day :-)

    How could I correct the erroneous value on the property window of an SQL Table.

    My problem is that, if I am going to display the property window of Table1, the 'Rows' information displays 115. However, if I am going to execute - Select Count(*) from Table1 then it returns 117. How could I fix this glitch?

    Please Help :-)

  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    Run UPDATE STATISTICS on the table(s).

    Also, Enterprise Manager checks the state of various databases and database objects when it first starts up, or when they are first selected. It won't reflect changes to the database made since the initial check unless you refresh the Enterprise Manager view.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

  3. #3
    Join Date
    Feb 2004
    One Flump in One Place
    It isn't strictly a glitch either - they are both counting different things. Anyway - more info in a currently active thread
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts