SQL err0r 1540 - Cannot Sort Row

[Laneyh]

Getting Ole error Cannot sort a row of size 8164, which is greater than the allowable maximum of 8094
When trying to run a Select query
Any ideas on the cause of this or if there is a way to increase maximum size ?

 

[tlbroadbent]

There is no way to increase the sort size. Does your query have a DISTINCT, GROUP BY or ORDER BY clause? You will need to reduce the number of columns in a select list and/or GROUP BY or ORDER BY clause.

If you have a UNION, SQL sorts the entire row. You can stop the sort by adding ALL to the UNION clause. Of course, SQL will no longer eliminate duplicates.

Select * from table1
UNION ALL
Select * from table2 Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.