MS SQL 2000 SP3 (8.00.856) -- Error 1501 Severity 20.

I am currently encounter a problem whereby my sql 2000 server repetitively generates error 1501 (severity 20) -- Sort Failure.

The information available on the web only covers MS SQL 6.5. Apparently, I was informed that this error should not have encountered in MS SQL 2000.

So, if there is anybody out there that can help me in troubleshooting this problem, please do help me as I am really stuck.Hi,

which state does the error message tell you ?

http://www.lcard.ru/~nail/sybase/error/13243.htm

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||The state of the error message is 1. The database is MS SQL 2000 with SP3.

Unfortunately, the error state is not listed in the URL document you specified.|||

What is the usage of TEMPDB in this environment?

I guess that couldbe a problem check this KBA http://support.microsoft.com/kb/826433 that explains bits and piece of these errors. Confirm the service pack level on SQL Server.