Hi 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