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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  ORDER BY FAILS WHEN ROW SIZE EXCEEDS 8094??

Author  Topic  Vijay Starting Member 8 Posts Posted - 2001-10-16 : 15:55:01 Hi, I got the following error when I tried to select rows from two different Tables and order by some of the columns. "Cannot sort a row of size 8113, which is greater than the allowable maximum of 8094". If I do not use order By Clause, I have no problem. Is there a way we can avoid seeing this error, or is there a way by which we can increase the allowable limit in sql server? Thanks in advance. Regards, Vijay