• I know you've done this now, funnily enough I was doing service packs for various versions of SQL on the weekend. Worth noting that in SQL 2008r2 you get no warning or prompt to stop the main sql service, it just stops while you are applying the sp!

    One to watch out for if you need to service pack any newer versions than 2005!