FIX: A hotfix for Microsoft SQL Server 2000 Service Pack 4 may not update all the necessary files on an x64-based computer

Article translations Article translations
Article ID: 934203 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

When you install a Microsoft SQL Server 2000 Service Pack 4 (SP4) hotfix that has a build version that is earlier than 8.00.2244 on an x64-based computer, the hotfix does not update all the necessary files.

This installation issue occurs when the system uses the Advanced Micro Devices (AMD) AMD64 processor architecture or the Intel Extended Memory 64 Technology (EM64T) processor architecture.

Note This issue does not occur on systems that use the Intel Itanium processor architecture.

CAUSE

This problem occurs because the hotfix does not correctly determine the locations of the files that must be updated on an x64-based computer. This problem occurs when the files that must be updated are in one of the following SQL Server 2000 folders:
  • COM
  • Tools
For example, if you have SQL Server 2000 installed on the C drive of an x64-based computer, the following locations may not be updated correctly:
  • C:\Program Files(x86)\Microsoft SQL Server\80\Tools\Binn
  • C:\Program Files(x86)\Microsoft SQL Server\80\COM

RESOLUTION

A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem.

If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, submit a request to Microsoft Customer Service and Support to obtain the hotfix.

Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site:
http://support.microsoft.com/contactus/?ws=support
Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.

Prerequisites

There are no prerequisites for installing this hotfix.

Restart requirement

You do not have to restart your computer after you apply this hotfix.

Hotfix replacement information

This hotfix does not replace any other hotfixes.

File information

The English version of this hotfix has the file attributes (or later file attributes) 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 item in Control Panel.
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
80sp4-tools.sqlNot Applicable134,62818-Feb-200609:40Not Applicable
Distmdl.ldfNot Applicable786,43210-Mar-200707:53Not Applicable
Distmdl.mdfNot Applicable2,359,29610-Mar-200707:53Not Applicable
Dtsui.dll2000.80.2244.01,593,34410-Mar-200709:29x86
Impprov.dll2000.80.2244.0102,40010-Mar-200709:29x86
Instdist.sqlNot Applicable751,63328-Nov-200623:42Not Applicable
Inst_repl_hotfix.sqlNot Applicable3628-Feb-200702:03Not Applicable
Msgprox.dll2000.80.2244.094,20810-Mar-200709:29x86
Msrpjt40.dll4.10.9424.0188,47310-Mar-200709:29x86
Mssdi98.dll8.11.50523.0239,10410-Mar-200709:29x86
Ntwdblib.dll2000.80.2244.0290,81610-Mar-200709:29x86
Odsole70.dll2000.80.2244.069,63210-Mar-200709:29x86
Osql.exe2000.80.2244.057,34410-Mar-200709:29x86
Pfclnt80.dll2000.80.2244.0430,08010-Mar-200709:29x86
Procsyst.sqlNot Applicable552,06816-Jun-200508:15Not Applicable
Qrdrsvc.exe2000.80.2244.0192,51210-Mar-200709:29x86
Replcom.sqlNot Applicable1,216,65910-Mar-200706:34Not Applicable
Replcom_baseline.sqlNot Applicable1,214,94208-Dec-200610:08Not Applicable
Replmerg.exe2000.80.2244.0163,84010-Mar-200709:29x86
Replmerg.sqlNot Applicable1,151,52110-Mar-200706:33Not Applicable
Replmerg_baseline.sqlNot Applicable1,151,75828-Feb-200702:03Not Applicable
Replprov.dll2000.80.2244.0237,56810-Mar-200709:29x86
Replrec.dll2000.80.2244.0315,39210-Mar-200709:29x86
Replsub.dll2000.80.2244.0270,33610-Mar-200709:29x86
Replsys.sqlNot Applicable1,096,99008-Dec-200610:03Not Applicable
Replsys_baseline.sqlNot Applicable1,096,45708-Dec-200610:08Not Applicable
Repltran.sqlNot Applicable1,000,69128-Nov-200623:42Not Applicable
Repltran_baseline.sqlNot Applicable999,41308-Dec-200610:08Not Applicable
Rinitcom.dll2000.80.2244.0278,52810-Mar-200709:29x86
Semexec.dll2000.80.2244.0856,06410-Mar-200709:29x86
Semmap.dll2000.80.2244.053,24810-Mar-200709:29x86
Snapshot.exe2000.80.2244.061,44010-Mar-200709:29x86
Sp4_serv_qfe.sqlNot Applicable18,81016-Jun-200508:15Not Applicable
Sqlagent.exe2000.80.2244.0323,58410-Mar-200709:29x86
Sqldiag.exe2000.80.2244.0118,78410-Mar-200709:29x86
Sqldmo.dll2000.80.2244.04,362,24010-Mar-200709:29x86
Sqldumper.exeNot Applicable22,52810-Mar-200709:29x86
Sqlevn70.rll2000.80.2244.045,05610-Mar-200708:29Not Applicable
Sqlfth75.dll2000.80.2244.0102,40010-Mar-200709:29x86
Sqlservr.exe2000.80.2244.09,175,04010-Mar-200709:29x86
Sqlsort.dll2000.80.2244.0589,82410-Mar-200709:29x86
Stardds.dll2000.80.2244.0176,12810-Mar-200709:29x86
Svrnetcn.dll2000.80.2244.0110,59210-Mar-200709:29x86
Ums.dll2000.80.2244.035,84010-Mar-200709:29x86
Xpstar.dll2000.80.2244.0311,29610-Mar-200709:29x86

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For more information about how to use 32-bit versions of SQL Server 2000 SP4 on an x64-based computer, click the following article number to view the article in the Microsoft Knowledge Base:
898042 Changes to SQL Server 2000 Service Pack 4 operating system support
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.

Properties

Article ID: 934203 - Last Review: October 8, 2011 - Revision: 4.0
APPLIES TO
  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 Personal Edition
Keywords: 
kbautohotfix kbexpertiseinter kbexpertisebeginner kbprb kbfix kbbug kbHotfixServer kbqfe KB934203

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com