System.Data.SqlClient.SqlException - Cannot sort a row of size 8111, which is greater than the allow

  • Thread starter Thread starter Robert Somers
  • Start date Start date
R

Robert Somers

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"
 
Back
Top