One of the restrictions of SQL Server 2005 (and now in 2008) is that you cannot include an ORDER BY within a view. This presumably is to remove the possibility of a “double sort” where the view ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results