MSSQLSERVER_41399
Applies to: 
SQL Server
Details
| Attribute | Value |
|---|---|
| Product Name | SQL Server |
| Event ID | 41399 |
| Event Source | MSSQLSERVER |
| Component | SQLEngine |
| Symbolic Name | MAX_SORT_ROW_WIDTH_EXCEEDED |
| Message Text | The sort operation is too complex. Consult SQL Server Books Online for more information. |
Explanation
Sorting the result of join and aggregation operations increases the complexity of the sort operation by increasing the size of the row in the sort buffer. This error means that the size of the row is larger than the maximum size supported by the sort operator in natively compiled stored procedures. Note that the size of a row in the sort buffer is determined solely by the number of joins and the number and type of aggregate functions. The size of the rows in the base tables does not affect the size of the row in the buffer.
User Action
Decrease the complexity of the query by removing joins or aggregate functions.
See Also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for