If you've got a SQL 2000 solution in place somewhere and are looking to upgrade it to SQL 2005 in the near future, then there is a solution to help you do this now.
Its called the Upgrade advisor. Its been through some serious changed due to some great feedback the team got.
Its a free download - so if you want to look to upgrade to SQL 2005 - you should download it.
Update: Links fixed - thanks Riki!