This problem only occurs if you have upgraded the MSDE RTM build (194.01) directly to Service Pack 2. It does not occur on any other incarnations of the MSDE 2000 product. Additionally, the problem does not occur if you first upgrade from the release to manufacturing (RTM) version to MSDE 2000 Service Pack 1, and then upgrade to MSDE 2000 Service Pack 2.
The English version of this fix has the file attributes (or later) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
For instructions about how to apply a patch package to MSDE 2000, see the "Applying Patch Packages" section in the following Readme.txt file:
Date Size File name
9/7/2002 21,950,464 bytes Sqlrun01.msp
9/7/2002 21,950,464 bytes Sqlrun02.msp
9/7/2002 21,950,464 bytes Sqlrun03.msp
9/7/2002 21,950,464 bytes Sqlrun04.msp
9/7/2002 21,950,464 bytes Sqlrun05.msp
9/7/2002 21,950,464 bytes Sqlrun06.msp
9/7/2002 21,950,464 bytes Sqlrun07.msp
9/7/2002 21,950,464 bytes Sqlrun08.msp
9/7/2002 21,950,464 bytes Sqlrun09.msp
9/7/2002 21,950,464 bytes Sqlrun010.msp
9/7/2002 21,950,464 bytes Sqlrun011.msp
9/7/2002 21,950,464 bytes Sqlrun012.msp
9/7/2002 21,950,464 bytes Sqlrun013.msp
9/7/2002 21,950,464 bytes Sqlrun014.msp
9/7/2002 21,950,464 bytes Sqlrun015.msp
9/7/2002 21,950,464 bytes Sqlrun016.msp
NOTE: Because of file dependencies, the most recent hotfix or feature that contains the files may also contain additional files.
Depending on the original Windows Installer package file (.msi) that was used to install MSDE 2000, you have to apply only one of the patch files (.msp) to your existing MSDE installation. For example, if you used Sqlrun01.msi to install MSDE 2000 RTM, you must use the Sqlrun01.msp file that is shown in the list. For Sqlrun02.msi, you must use Sqlrun02.msp.
After you apply the patch package, you can successfully remove MSDE 2000.
For additional information about how to determine which Windows Installer file was used for your MSDE installation, click the article number below to view the article in the Microsoft Knowledge Base:
This problem was first corrected in Microsoft SQL Server 2000 Service Pack 3.
C:\> setup.exe /x [package_file] /L*v [filename]
For example, if you originally installed MSDE 2000 by using the Sqlrun01.msi package, you can use this syntax
C:\>setup.exe /x sqlrun01.msi INSTANCENAME="MYMSDE" /L*v C:\MSDE_Uninstall.log
where MYMSDE is the instance name used at the time of the MSDE installation. Additionally, you must specify the name of the same installation package file that was used to install the instance of the Desktop Engine.
NOTE: Copy the .msi file to the same folder as the Setup.exe file.
You may also use the Windows Installer tool to remove MSDE 2000.
For additional information about the complete list of the available command line switches, click the article number below to view the article in the Microsoft Knowledge Base:
Article ID: 317619 - Last Review: Jun 19, 2014 - Revision: 1