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 ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback