After attempting twice to install Vista's new Service Pack 2, I've found that if you've enable the administrator account and assigned a password to that account, windows updates will fail.
To install the updates successfully, go to the Control Panel => Administrative Tools => Computer Management => Local Users and Groups => Administrator. Right click the Administrator account and choose Properties. Choose to disable the account.
You should now be able to install the updates without further problems.
Good Luck