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

    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
    Location
    Ohio
    Posts
    12,592
    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
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    It isn't strictly a glitch either - they are both counting different things. Anyway - more info in a currently active thread http://www.dbforums.com/showthread.php?t=1608419
    Testimonial:
    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
  •