MS SQL: Cannot sort a row of size 8183, which is greater than the allowable maximum of 8094
Posted on 2003-03-13
I am running a the following query against a database of contacts:
WHERE (contact_status = 1)
ORDER BY contact_last_name, contact_first_name
I get the following error.
Microsoft OLE DB Provider for SQL Server error '80040e14'
Cannot sort a row of size 8183, which is greater than the allowable maximum of 8094.
/hr/candidate_list.asp, line 45
contact_id = int
contact_last_name = varchar(100)
contact_first_name = varchar(100)
I have 9933 rows of data in this table. How can I get SQL server to not fail when trying to sort? Do I need to create an index for those fields (contact_last_name & contact_first_name)?
What can I do?