For some reason my views are no longer sorting in SqlServer 2005.
I migrated my database from SqlServer 2000 to SqlServer 2005 and now my sort by clause in all my views no longer work. Why is this, and is there a change that I can make to restore sorting in views.
For example, this view does not return the results sorted by name, when before in SqlServer 2000, it did.
create view myView
select top 100 percent name, id from mytable
order by name