Yes I'm querying the view directly from the code, I'm doing the order by in the view instead of the code and it was working with SQL 2000.

I have modified...

Thanks for your reply.

I found hotfix from microsoft to solve this problem

http://support.microsoft.com/kb/926292/en-us

I applied it but it's not working also.

I think the only solution is to modify the Select statement...