Freigeben über

How to uninstall HOTFIXES manually when the base SQL 2000 is not there in the box

  • Artikel

Consider a scenario where SQL 2000 has been uninstalled and Hotfixes are still visible. In my case it was hotfix 2050 and 2273. One will find the hotfix components visible in the ADD\REMOVE program. In that scenario attempts of removing the hotfixes are unsuccessful from the ADD\REMOVE programs. Attempts of removing the same from C:\Winnt\-->Uninstall or C:\Windows\-->Uninstall will fail.

SOLUTION

***********

For this specific issue, Searched in registry for the Hotfixes 2273 and 2050 and found them in the below locations.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\Microsoft SQL Server 2000 \<INSTANCENAME>\ SP4\KB948110(ENU) ==>KB number for the patch in my case

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\ <KB OF THE PATCH>

Took the backup of the entire registry, and then deleted the below keys,

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\Microsoft SQL Server 2000

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\ <KB OF THE PATCH>

Closing the Add/Remove programs, and reopening it removed the hotfixes from the list.

 

Note: This post should not be treated as the Microsoft’s Recommendation or Resolution to the problem, it is only a workaround which worked in our environment and so we would like to share it.

 

Dibakar Dharchoudhury

SE, Microsoft SQL Server,

Reviewed By,

Rakesh Singh,

TL, Microsoft SQL Server

Comments

  • Anonymous
    June 13, 2009
    Thanks for sharing that info. Needed that I was facing the same problem and wasted my 3 hours googling for the solution. It worked. :)

  • Anonymous
    June 03, 2010
    Work also for me. Thanks

  • Anonymous
    October 29, 2010
    Did this actually remove the HOTFIX or was it already uninstalled??  2050 is showing up as 18GB (+/-).  Is it already uninstalled?