SqlException: Could not insert a row larger than the page size into a hash table. Resubmit the query with the?

Question

Dear All,

I'm getting the above error when i execute the select query from the table which contains more than 80 thousand records.

Can anyone pour few ideas over it.

Answer 1

for sql u can only do insert for at most 500 records at a time. spilt the records? but that is tedious.
what database are u using?
for Mysql, insert using data the mysql import statement.
for db2: use the command console to insert the datas

Answer 2

This usually means you are trying to run a complex query with a row width that the optimizer can't handle (typically due ot use of wide CHAR or VARCHAR columns). In SQL Server 7.0 and up, you can solve this issue by adding OPTION ROBUST PLAN to your query

look this site : http://tutorials.aspfaq.com/8000xxxxx-errors/why-do-i-get-80040e14-errors.html

Answer 3

Check out the link below and look at the section on adding the ROBUST PLAN hint.