I mentioned that I spotted some regression in SQL Server 2008 SP1 regarding the ORDER BY within a VIEW. The history behind this is that the ORDER BY clause was allowed in SQL Server 2000 Views and ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results