Migrating SQL Server 2000 to SQL Server 2008
If you're asking how to get this information from a SQL Server 2008 installation, then use sys.sql_modules to find the text of a procedure/view

select m.definition
    from sys.views v 
    join sys.sql_modules m 
        on v.object_id = m.object_id
    where definition like '%ORDER[ ]BY%'


or

   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.).