You can see the following post on my upgrade path to SP2 on SCCM 2007.  Below that is a short list of my post upgrade tasks, which will be done in the months following, but not the night of the upgrade…

http://t3chn1ck.wordpress.com/2009/11/05/my-sccm-2007-sp2-upgrade-path/

Post Upgrade Tasks

  1. Upgrade all consoles with SP2 files
  2. Deploy SCCM SP2 client
  3. Deploy Windows Update Agent 7.4.7600.226
  4. Deploy latest version of Nomad Branch