Over the last few days KB970892 has consitently failed to install on our SQL Servers via Windows Update. The following instructions will get it working.
Once the update fails to install, you’ll likely have to reboot as the system will be flagged as pending a reboot. Once rebooted we need to attempt to complete the SQL [...]

As Neil points out in his blog, SQL 2008 RTM’d and is available on Technet / MSDN. Typical, I only setup 2005 Enterprise for SCCM  in my lab environment yesterday.

Time to take this for a spin. Keep an eye on Neil’s blog, he has more SQL2008 goodness planned.

This guide focuses on VS2005 Express Edition with advanced services, though this applies to any version of SQL2005.
The first thing you’ll need to do is copy the install files to your distribution share via the Deployment Workbench. Be sure to choose a directory structure without spaces as this seems to cause problems during setup.
Once you’ve [...]