Question

Does anyone know exactly what this error message means?
"Cannot create a worktable row larger than allowable maximum. Resubmit your
query with the ROBUST PLAN hint."
I get this error when trying to display SQL query results in my browser but
when I run the same query using Query Analyser, I don't get this error.
Is this ODBC related or pure SQL?
Thanks.Just search Books Online for "ROBUST PLAN" and you will find what optimizer hint you need to put in
the query. Basically, the optimizer selected a plan where temp storage resulted in a row size over
page size. The hint tell the optimizer to not do that.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Johann Castueras" <johann.castueras@.bigpond.com> wrote in message
news:%23YJw%23WXiDHA.2320@.TK2MSFTNGP12.phx.gbl...
> Does anyone know exactly what this error message means?
> "Cannot create a worktable row larger than allowable maximum. Resubmit your
> query with the ROBUST PLAN hint."
> I get this error when trying to display SQL query results in my browser but
> when I run the same query using Query Analyser, I don't get this error.
> Is this ODBC related or pure SQL?
> Thanks.
>|||What is the statement you are using ?
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.
Also
http://support.microsoft.com/default.aspx?scid=kb;en-us;280138
What version and SP level of SQL Server are you running?
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Johann Castueras" <johann.castueras@.bigpond.com> wrote in message
news:%23YJw%23WXiDHA.2320@.TK2MSFTNGP12.phx.gbl...
> Does anyone know exactly what this error message means?
> "Cannot create a worktable row larger than allowable maximum. Resubmit
your
> query with the ROBUST PLAN hint."
> I get this error when trying to display SQL query results in my browser
but
> when I run the same query using Query Analyser, I don't get this error.
> Is this ODBC related or pure SQL?
> Thanks.
>