My colleagues in the USA have been running some great application compatibility labs with our early adopters - and part of that lab has involved using a new tool which has now been made available for all. The SQL Server 2005 Upgrade Advisor can be used by database developers and administrators to analyze SQL Server 7.0 and SQL Server 2000 database servers in preparation for upgrading to SQL Server 2005. You can download the tool from http://www.microsoft.com/downloads/details.aspx?FamilyID=CF28DAF9-182E-4AC2-8E88-F2E936558BF2&displaylang=en 

In the UK my early adopters have reported very few problems (touch wood) with getting their SQL Server 2000 databases and applications running on SQL Server 2005 - but the arrival of this tool is definitely good news. I recommend all folks looking to move to SQL Server 2005 (and even those who already have) make use of this tool - just in case :-)