MK Softwaredevelopment GbR

Already tried to apply the instructions given in Microsoft Knowledebase Article 926292 (FIX: When you query through a view that uses the ORDER BY clause in SQL Server 2008, the result is still returned in random order ) ?

a small step-by-step manual:

1. Get the latest cumulative update package for your platform
at the time I wrote this entry (2009-02-13) it is cumulative update package 3 (Build 10.00.1787) and can be found here.

After receiving the download-link (including the password), download the file and unpack it

2. Install the hotfix
guess you don't need instructions for double-clicking on an EXE-file and following the installation instructions... ;-)

Actions after you apply this hotfix
According to the KB Article "This hotfix introduces trace flag 168. After you apply this hotfix, you must enable trace flag 168. "

you can accomplish this by either
3a. Enable Trace flag 168 manually
Everytime you startup SQL-Server execute "DBCC TRACEON(168,-1)" against the instance.

3b. Enable Trace flag 168 permanently
open up
Start
     -> All Programs
     -> Microsoft SQL Server 2008
     -> Configuration Tools
     -> SQL Server Configuration Manager

Open the properties of the instance of SQL Server in this example "SQL Server (MSSQLSERVER)" and add ";-T168" at the end of the Startup Parameters

screenshot of the SQL-Server-Properties dialog

5. (Re-)Start SQLServer

6. Set the compatibility Level of the Database to SQL-Server 2000

screenshot of the Database-Properties dialog

Finished