Cannot create a worktable row larger than allowable maximum. Resubmit your query with the ROBUST PLA

microsoft.public.sqlserver.programming

4 Nov 2005 2:57 PM

pdobos375

I am getting this error message (Cannot create a worktable row larger than
allowable maximum. Resubmit your query with the ROBUST PLAN hint.) when
trying to run the following SELECT query:

SELECT a.*,a.Model_Number AS
Model_Number,convert(varchar(40),b2.Product_Line) AS
Product_Line_NumberP,a.Product_Line_Number AS
Product_Line_Number,a.Description AS Description,a.Active AS Active FROM
Models a LEFT OUTER JOIN Product_Lines b2 ON
a.Product_Line_Number=b2.Product_Line_Number ORDER BY Model_Number

The query is part of a content management system, so it's called on an ASP
page that should list all the Product entires in the database. This query
runs fine every time I try it in Query Analyzer, but always generates the
error when it's run on the ASP page. I don't know what is causing it or how
to fix it. I have tried adding in "OPTION (ROBUST PLAN)" at the end of the
query, but that had no effect whatsoever. Any advice would be greatly
appreciated. Thank you.

Peter

4 Nov 2005 3:15 PM

marcmc

If you can run it in QA, it is an ASP issue!