Very Computer

Server: Msg 510, Level 16, State 2, Line 60
Cannot create a worktable row larger than allowable
maximum. Resubmit your query with the ROBUST PLAN hint.

TIA, Jordan

Did you try searching for ROBUST PLAN in the Books Online? That's the first
place you should always look.

Hints like this one are added as part of the OPTION clause at the end of the
query:

SELECT
FROM
WHERE
OPTION (ROBUST PLAN)

The BOL goes on to describe ROBUST PLAN:

ROBUST PLAN
Forces the query optimizer to attempt a plan that works for the maximum
potential row size, possibly at the expense of performance. When the query
is processed, intermediate tables and operators may need to store and
process rows that are wider than any of the input rows. The rows may be so
wide that, in some cases, the particular operator cannot process the row. If
this happens, SQL Server produces an error during query execution. By using
ROBUST PLAN, you instruct the query optimizer not to consider any query
plans that may encounter this problem.

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com

Quote:> In SS 7.0, I am getting this error and I cannot find any
> syntactical reference to show me how to add to my query.
> Does anyone know what I can do to implement this to see
> why my query is failing?

> Server: Msg 510, Level 16, State 2, Line 60
> Cannot create a worktable row larger than allowable
> maximum. Resubmit your query with the ROBUST PLAN hint.

> TIA, Jordan

Thank you for the help.  I did look in BOL but I was
unaware of the OPTION() syntax.

Thanks again.

Quote:>-----Original Message-----
>Hi Jordan

>Did you try searching for ROBUST PLAN in the Books

Quote:>place you should always look.

>Hints like this one are added as part of the OPTION

Quote:>query:

>SELECT
>FROM
>WHERE
>OPTION (ROBUST PLAN)

>The BOL goes on to describe ROBUST PLAN:

>ROBUST PLAN
>Forces the query optimizer to attempt a plan that works
for the maximum
>potential row size, possibly at the expense of