Hi All,

I have a stored procedure that gives the following error:

With the Robust Option
-----------------------------------------------------------------------------------------------------------------------

DTSStep_DTSExecuteSQLTask_2
DTSRun OnError:  DTSStep_DTSExecuteSQLTask_2, Error = -2147217900 (80040E14)
Error string:  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.
Error source:  Microsoft OLE DB Provider for SQL Server
Help file:        Help context:  0
Error Detail Records:      Error:  -2147217900 (80040E14); Provider
Error:  8619 (21AB)
Error string:  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.
Error source:  Microsoft OLE DB Provider for SQL Server
Help file:        Help context:  0
DTSRun OnFinish:  DTSStep_DT...  Process Exit Code 1.  The step failed.

After removing Robust Option
--------------------------------------------------------------------------------------------------------------

DTSRun:  Executing...   DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_2
DTSRun OnError:  DTSStep_DTSExecuteSQLTask_2, Error = -2147217900 (80040E14)
Error string:  Cannot create a worktable row larger than allowable
maximum. Resubmit your query with the ROBUST PLAN hint.
Error source:  Microsoft OLE DB Provider for SQL Server
Help file:        Help context:  0
Error Detail Records:      Error:  -2147217900 (80040E14);
Provider Error:  510 (1FE)      Error string:
Cannot create a worktable row larger than allowable maximum. Resubmit
your query with the ROBUST PLAN hint.
Error source:  Microsoft OLE DB Provider for SQL Server
Help file:        Help context:  0
DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_2
DTSRun:  Package execution complete.  Process Exit Code 1.  The step failed.

I'm really not sure what to do past here.  Can anyone help?

Thanks,
Bob Williams

how to pass in a long string to stored procedure
Need Help With a Simple Query
Error converting data type varchar to numeric
Check int value
Strange characters with Bulk Load