Selection From Sorted Subquery Is Unsorted In SQL Server 2005

I have some relatively simple SQL that acts differently between SQL Server 2000 and 2005. Although it is easy to fix I'd like to know if this difference is expected (documented) or a bug, and if there is perhaps a setting/switch I can use to avoid a code review of hundreds of stored procs to look for similar scenarios.


Executed the following script in SQL Server 2005 –

CREATE TABLE #Floats
(
FloatID INT IDENTITY,
FloatNumber FLOAT NOT NULL
)

DECLARE @sngCounter float
SET @sngCounter = 20
WHILE @sngCounter >= 0
BEGIN
INSERT INTO #Floats ( FloatNumber ) VALUES( @sngCounter )
SET @sngCounter = @sngCounter - 1
END
SELECT * FROM (SELECT TOP 100 PERCENT * FROM #Floats ORDER BY FloatNumber) AS FloatNumbers

DROP TABLE #Floats
GO

Produces the following resultset –
FloatID FloatNumber
----------- -----------
1 20
2 19
3 18
4 17
5 16
6 15
7 14
8 13
9 12
10 11
11 10
12 9
13 8
14 7
15 6
16 5
17 4
18 3
19 2
20 1
21 0

In SQL Server 2000 resultset is this –
FloatID FloatNumber
----------- --------
21 0.0
20 1.0
19 2.0
18 3.0
17 4.0
16 5.0
15 6.0
14 7.0
13 8.0
12 9.0
11 10.0
10 11.0
9 12.0
8 13.0
7 14.0
6 15.0
5 16.0
4 17.0
3 18.0
2 19.0
1 20.0