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 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results