Cannot sort a row of size 8872 which is greater than the allowable

Cannot sort a row of size 8872 which is greater than the allowable

Post by TmlnZWwgUm » Tue, 23 Nov 2004 06:45:04


max row size is 8060.
Queries that create a work table can also fall foul of this - e.g. anything
with an order by or union.

Sounds like it might be a good idea to split the table.
 
 
 

1. Cannot create a row of size x which is greater than the allowable maximum of 8060?

2. System.Data.SqlClient.SqlException - Cannot sort a row of size 8111, which is greater than the allowable maximum of 8094.

Is this a limitation of the data reader, the database, or the driver?
Is there a way to return the result of a query that returns rows
larger than 8094 bytes?

The maximum my current dataset should have is: 8330 (Based on the size
of the combined fields in the query.)

ToString() output:
------------------------------------------------------------------
"System.Data.SqlClient.SqlException: Cannot sort a row of size 8111,
which is greater than the allowable maximum of 8094.\r\n at
System.Data.SqlClient.SqlDataReader.Read()\r\n at
LanguageSupport.LanguageSupport.loadLanguages() in
c:\\inetpub\\wwwroot\\languagesupport\\languagesupport.cs:line 217"

3. SqlException:Cannot create a row of size X which is greater than m

4. 1481 tjxfofo@gmail.com 8872

5. Business cards on Publisher 2003 using Avery 8872

6. Cannot create a worktable row larger than allowable maximum.

7. parition question: "Fixed size" vs "Fill to maximum allowable size"

8. sort data rows "greater than or equal" criteria in another cell

9. Way to not sort when only a header row and one row of data to sort?

10. Way to not sort when only a header row and one row of data to sort

11. Row size exceed row size limit

12. string size greater than page size?

13. window/form size greater than screen size

14. Shared memory segment that has size greater than size of phisycal memory of the machine