BRIAN MORRIS TECHNOLOGY SERVICES

[SOLUTION] Failed – Security Update for SQL Server 2005 Service Pack 3 (KB970892)

After scouring the internet I found a solution for my computer’s inability to update the Security Update for SQL Server 2005 Service Pack 3 (KB970892) (Update failed). 

Click Start, Run, type “regedit”

Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup

Double-click on Resume, change the number from 1 to 0 (zero).

Try to install now.  It worked for me.

Source: http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/bad23a21-2009-46ad-b4d8-1c4fcd796050  (the instructions weren’t exactly correct)