"Cannot sort a row of size" how to resolve

I have a SQL Stored Procedure which select data from some tables. I worked on some rows but when I inserted one more row which had a large data- new row has inserted but I cannot select and order its record and SQLsrv raised this error
"Cannot sort a row of size 8154, which is greater than the allowable maximum of 8094"
any one, plz help me to Fix this.
Thanks alotThe row size extends a maximum page length - You will have to normailze the data further or reduce the attribute lengths - Can you post the table schema (DDL)?