TechRepublic|Forums|Networks

Networks

General discussion

  • Creator
    Topic
  • June 9, 2000 at 7:30 pm #2074671

    Index tuning error on MS SQL server

    Locked

    by grrrkid · about 21 years, 11 months ago

    Everytime I try to run the Index tuning wizard over a particular set of queries I get the following:

    “Error analyzing query(62)”. I have looked this up in technet and BOL and searched far and wide for answers. I can’t find any reference to this error anywhere. Does anyone know what it means and/or how to solve it?

    It seems to only happen for a particular table, but the table structures are fine, dbcc, etc gives a good result.

    Help me if you can.

    Regards,
    GK

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Comments

  • Author
    Replies
    • June 9, 2000 at 10:05 pm #3777810

      Index tuning error on MS SQL server

      by guy · about 21 years, 11 months ago

      In reply to Index tuning error on MS SQL server

      I found this in Technet: It was a VB article found by searching for Query near 62. The error could make sense in your database situation.

      Case ErrInputPastEndOfFile ‘ Error 62
      strMsg = “This file has a nonstandard end-of-file marker, ”
      strMsg= strMsg & “or an attempt was made to read beyond ”
      strMsg = strMsg & “the end-of-file marker.”
      Case Else

    • June 15, 2000 at 3:42 am #3776708

      Index tuning error on MS SQL server

      by m2 · about 21 years, 11 months ago

      In reply to Index tuning error on MS SQL server

      Since event class 62 for traces is ?replay error?, it would make sense that a replay error is the cause of your problem. Check out Replaying Traces in BOL for some possible sources of errors.

      Hope this helps.

    • August 11, 2000 at 4:55 pm #3770769

      Index tuning error on MS SQL server

      by headbangerphil · about 21 years, 9 months ago

      In reply to Index tuning error on MS SQL server

      you say it occures in a particular table?, why not try sp_table_validation, to check row count or checksum differences

    • September 20, 2000 at 7:04 pm #3754490

      Index tuning error on MS SQL server

      by grrrkid · about 21 years, 8 months ago

      In reply to Index tuning error on MS SQL server

      This question was auto closed due to inactivity

  • Author
    Replies
Viewing 3 reply threads