Open the Security Centre from the tray icon or Control Panel. To the left, under Resources, last item, there's an option to change the way alerts are sent. Click that, and turn off the alert in respect of Automatic Updates.
I turn all of them off. I find this SP2 Security Centre does virtually nothing and is a real pain, and there's no official way to disable it unless the machine is on a domain using XP Pro.