• Definitely use the upgrade advisor. Watch out for older scripts that check system tables as many of them have changed.

    I assume you are doing a test upgrade, but please make sure this is done on another machine. Upgrades in place are tricky, and can leave you stuck. Make sure you have good backups (2 copies) and enough time to reinstall SQL 2K if something goes awry.