Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

The ORDER BY clause can stay there, it's just that the behavior of your app may change. You may want to check your app for locations that rely on ordering without an explicit ORDER BY - those will have to be corrected whether you drop the ORDER BY from your views or not...
–
Aaron Bertrand♦Jan 7 '13 at 19:14

select object_definition(object_id)
from sys.views v
where object_definition(object_id) like '%ORDER[ ]BY%'

If you're asking how to get the information from the SQL Server 2000 database, why not backup and restore? Or you can connect to your SQL Server 2000 instance using SSMS, right click on the database, choose "Generate Scripts" and select all objects (or views, or procedures, etc.).

One thing to note that we found when converting one of our projects, if you've used the select top 100 ... order by abuse :) then this will no longer work. Though I've forgotten the details, I think 2008 just ignores the order by completely!

As a temporary and ugly workaround you can change it to select top 99.99 ... order by.

Not sure if there's a solution that you can implement just in the view though.