I created a view in the AdventureWorks db, showing the contact names. I then specified an ascending sort on the name column. All works exactly as expected.
Now I save and close the view. I then "Open View" to once again see the output. The names are no longer sorted properly, as if it's completely ignoring my sort setting. What's going on???