SQL 2000 to SQL2005 Conversion Questions

Here are a few things that you may want to consider in upgrading from SQL 2000 to SQL 2005:Change the DB compatibility setting from 9.0 to 8.0. This is because any forms that contain lookups using the asterisk for left join and right join (*= or =*) no longer work in higher versions of SQL.  If you don't want to lower the database compatibility level, you can use a TIER Tool to identify all forms that contain this and then fix these items prior to upgrading. (Please contact support for this tool and instructions on how it works.)Check Views - Some views use select top 100 % in them so that they can have an order by included at the end. From what we've read, this is not selecting a complete 100% and there's a remote chance that one item may actually end up missing from the list. Re-Index - The last thing we've had clients notice is that 2005 may take a different execution plan than 2000 did. This means that something that was once lightning fast when run against the 2000 server may now take a bit longer to complete.  We recommend re-indexing and updating statistics soon after you change the compatibility level.When installing newer versions of SQL Server, remember to use SQL Authentication and do not select allow for case sensitive information.