SQL Server 2008 Upgrade Guide

Document containing best practices when upgrading from 2000 or 2005 to SQL Server 2008

There's also a utility called Upgrade Advisor that will analyze your SQL 2000 or 2005 instance and reports possible upgrade issues