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!