ORDER BY has never been technically 'allowed' in a view definition. For example, the following code: CREATE VIEW dbo.[UsersByFirstName] AS SELECT * FROM dbo.[users] ORDER BY [FirstName] GO will throw an error if you attempt to run it. Books Online for
Read More...