Does anyone know this error?

[jianhua]

Hi,

Need your help! The error message is as follows:

ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot create a work table row larger than allowable maximum. Resubmit your query with the ROBUST PLAN hint.

The error occurred while processing an element with a general identifier of (CFSTOREDPROC), occupying document position ...

Based on this information, it seems to me the error is caused by the stored procedure. But the fact is it worked for a year, and suddenly one day last week it didn't and got this error. Does anybody know why?

 

[tleish]

I think the query probably still works, it may just be the parameters being passed to it. I'd pay special attention to:

"Cannot create a work table row larger than allowable maximum. Resubmit your query with the ROBUST PLAN hint."
- tleish

 

[jianhua]

Hi tleish,

Thanks for your quick response. If the parameters are larger than the allowable maximum, we got this error before.

ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.

What is the work table row? How to do a ROBUST PLAN hint? Do you think the problem is in the stored procedure or in the SQL Server?