Results 1 to 2 of 2

Thread: Row Size Error

  1. #1
    Join Date
    May 2003
    Location
    UK
    Posts
    220

    Angry Unanswered: Row Size Error

    Howdy

    I get an error :

    "Could not insert a row size larger than the page size inot a hash table.
    Resubmit the query with the Robust Plan hint"

    Now if a row has data larger than 8060 bytes, no big deal, it splits it over multiple
    pages etc , from what I understand. If this is the case, why would you get thate rror?

    The app is Crystal Reports and we cant insert the ROBUST PLAN hint into the query.

    Any suggestions?

    Cheers,

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Do you have a text field in this row? If not, then you need to limit the row to 8060 characters.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

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