I believe I found a Bug in MS SQL Server 8.0.


I have a query with an ORDER BY clause. The resultset is about 10000 rows.
Sometimes the ordering of the result is not correct, but when I restart the
sqlserver-process, at least the first time the ordering is correct, but then
after executeing the same query a few times, th ordering gets corrupt!


Has anybody encountered a simmilar Problem?

Does anybody know a workaround?


Thank a lot.

Andy Rohr.