Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajesha
Starting Member
36 Posts |
 Posted - 2003-11-07 : 00:38:36
|
| When am selecting a no of records by order by clause iam getting the following errorError Type:Microsoft OLE DB Provider for SQL Server (0x80040E14)Cannot sort a row of size 10231, which is greater than the allowable maximum of 8094.What should i do now? |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-11-07 : 05:14:50
|
Have you included text or large varchar columns in the ORDER BY clause? You might have to cut down the number of characters you are using for the sort.SELECT ID, LargeCol1, LargeCol2 FROM Table1 INNER JOIN Table2ON Table1.ID = Table2.IDORDER BY LEFT(LargeCol1, 2000), LEFT(LargeCol2, 2000)Owais
Where there's a will, I want to be in it. |
 |
|
|
|
|
|
Cannot sort a row of size 10231