Home All Groups Group Topic Archive Search About

How to use ROBUST PLAN in the query??

Author
15 Sep 2006 7:45 AM
Raghavendra Y Nayak
Hi:

I'm trying to retrieve a large record and I'm getting the
following error. Plz can anyone help...

Regards,
R Y Nayak
Server Error in '/fostering' Application.
--------------------------------------------------------------------------------

Could not insert a row larger than the page size into a hash table. Resubmit
the query with the ROBUST PLAN hint.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Author
15 Sep 2006 9:55 AM
ML
Look up query hints in Books Online:
http://msdn2.microsoft.com/en-us/library/ms181714.aspx

For a better answer please post your query. At the moment you're the only
one who can see it.


ML

---
http://milambda.blogspot.com/

AddThis Social Bookmark Button