ROBUST PLAN hint NOT the answer

[shadyness]

I have been programming an application in Cold Fusion MX with a SQL Server 2000 base that I created, where I have been trying to pass a component with a rather large and complicated query. I knew it was risky when I was creating and testing it, but it seemed to work. Finally I hit a page where I got the ominous "Could not insert a row larger than the page size into a hash table. Resubmit the query with the ROBUST PLAN hint." message. Upon attmepting to use a Robust Plan OPTION, the query will still not pass. SO my question is Am I just stuck with the limitations of SQL and I need to break apart the query, or is there something else I can do?

I can post the query if needed.

Thanks to all who can help!


<== Some people say they are afraid of heights. With me its table widths. ==>