I have recently rebuilt the master db to change the collation on one of my servers. When I did a select @@version it was at 650, which is sp2 with a security patch. I then installed sp3a on top of that and it worked ok, without rebooting it came with with version 8.00.760. I'm going to rebuild the master db on a production server.
I did not reboot the server after rebuilding and applying sp3a to the development server. Do I always need to reboot after applying a service patch? Thanks in advance.