][SQL Server]Cannot sort a row of size

Cannot sort a row of size 8155, which is greater than the
allowable maximum of 8094.][SQL Server 7.0]
Does anybody known how to fix this'"Jorge Balzo" <jbalzo@.eclac.cl> wrote:
> Cannot sort a row of size 8155, which is greater than the
> allowable maximum of 8094.][SQL Server 7.0]
> Does anybody known how to fix this'
--
Hi Jorge,
You have reached the maximum row size allowed in a select statement. You
need to either modify your view or table to include varchar() columns or
remove some of the columns so that the total datalength of the data row
doesn't exceed 8094 bytes that requires sorting.
Hope this helps,
--
Eric Cárdenas
SQL Server support|||You could try the ROBUST PLAN optimizer hint. I'm not sure whether it will help in your particular
situation, though.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Jorge Balzo" <jbalzo@.eclac.cl> wrote in message news:022601c3b9e1$ed8c7050$a501280a@.phx.gbl...
> Cannot sort a row of size 8155, which is greater than the
> allowable maximum of 8094.][SQL Server 7.0]
> Does anybody known how to fix this'
>