Error msg 8616

Hello,
I got this massage,
'Warning: The query processor could not produce a query plan from the
optimizer because the total length of all the columns in the GROUP BY or
ORDER BY clause exceeds 8000 bytes'
How I can do it?
Thanks,
JNHi, JN
I believe the full text of the error message is:
Server: Msg 8619, Level 16, State 2, Line <n>
Warning: The query processor could not produce a query plan from
the optimizer because the total length of all the columns in the
GROUP BY or ORDER BY clause exceeds 8000 bytes.
Resubmit your query without the ROBUST PLAN hint.
However, if you try your query without "OPTION (ROBUST PLAN)" you may
get the following error:
Server: Msg 1540, Level 16, State 1, Line <n>
Cannot sort a row of size <x>, which is greater than the allowable
maximum of 8094.
Am I correct so far ? If yes, you should redesign your query so that
any necessary sorting will be done on columns with a total length less
than 8000 bytes. We can help you with this task only if you post DDL,
sample data, expected results and your current query. See:
http://www.aspfaq.com/etiquette.asp?id=5006
Razvan

Error message

Does anyone know the meaning of this error message?
Event Type: Warning
Event Source: MSSQLServer
Event Category: (8)
Event ID: 19011
Date: 4/27/2007
Time: 10:21:33 PM
User: N/A
Computer:
Description:
SuperSocket info: (SpnRegister) : Error -2146893006.
Thank you.Hi
"GoFishing" wrote:
> Does anyone know the meaning of this error message?
> Event Type: Warning
> Event Source: MSSQLServer
> Event Category: (8)
> Event ID: 19011
> Date: 4/27/2007
> Time: 10:21:33 PM
> User: N/A
> Computer:
> Description:
> SuperSocket info: (SpnRegister) : Error -2146893006.
>
> Thank you.
>
Have you seen http://tinyurl.com/25uyv7
John