DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 933097 - Last Review: October 8, 2011 - Revision: 4.0

Microsoft distributes Microsoft SQL Server 2005 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2005 fix release.

On This Page

INTRODUCTION

Microsoft SQL Server 2005 hotfixes are created for specific SQL Server service packs. You must apply a SQL Server 2005 Service Pack 2 (SP2) hotfix to an installation of SQL Server 2005 SP2. By default, any hotfix that is provided in a SQL Server service pack is included in the next SQL Server service pack.

SQL Server 2005 SP2 includes all the SQL Server 2005 hotfixes up to and including build 9.0.2211. For more information about which SQL Server 2005 hotfixes are included in SQL Server 2005 Service Pack 2, click the following article number to view the article in the Microsoft Knowledge Base:
921896  (http://support.microsoft.com/kb/921896/ ) A list of the bugs that are fixed in SQL Server 2005 Service Pack 2
Cumulative hotfix package (build 3152) for SQL Server 2005 SP2 contains the SQL Server 2005 hotfixes that were not included in SQL Server 2005 SP2. This build approximately corresponds to build 9.0.2214 through build 9.0.2219.

Note This hotfix rollup build is also known as build 3152.

Important notes about the cumulative hotfix package

  • SQL Server 2005 hotfixes are now multilanguage. There is only one cumulative hotfix package for all languages.
  • One cumulative hotfix package includes all the component packages. The cumulative hotfix package is designed to update only those components that are installed on the system.
  • You must enable the SQL Server Management Object (SMO) extended stored procedures and the SQL Server Distributed Management Object (SQL-DMO) extended stored procedures before you install the cumulative hotfix package. For more information about the SMO and DMO XPs option, see SQL Server 2005 Books Online.

    Note SQL Server 2005 Books Online notes that the default setting of these stored procedures is 0 (off). However, this value is incorrect. By default, the setting is 1 (on).
  • To uninstall the cumulative hotfix package, follow these steps:
    1. Click Start, click Control Panel, and then click Add or Remove Programs.
    2. In Add or Remove Programs, click Change or Remove Programs.
    3. To see all the updates for the SQL Server 2005 installation, click to select the Show Updates check box.
    4. Uninstall the cumulative hotfix package.

MORE INFORMATION

How to obtain the cumulative hotfix package for SQL Server 2005 SP2 (build 9.0.3152)

Cumulative hotfix package for x86-based operating systems

If you are running any component of SQL Server 2005 on an x86-based operating system, you must install the following package. The following file is available for download from the Microsoft Download Center:

Collapse this imageExpand this image
Download
Download the SQLServer2005-KB933097-x86-ENU.exe package now. (http://download.microsoft.com/download/7/3/f/73fe973b-5273-433d-adf9-178e670a84bc/SQLServer2005-KB933097-x86-ENU.exe)

Release Date: March 7, 2007

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591  (http://support.microsoft.com/kb/119591/ ) How to obtain Microsoft support files from online services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

Cumulative hotfix package for x64-based operating systems

If you are running any component of SQL Server 2005 on an x64-based operating system, you must install the following package. The following file is available for download from the Microsoft Download Center:

Collapse this imageExpand this image
Download
Download the SQLServer2005-KB933097x64-ENU.exe package now. (http://download.microsoft.com/download/7/3/f/73fe973b-5273-433d-adf9-178e670a84bc/SQLServer2005-KB933097-x64-ENU.exe)

Release Date: March 7, 2007

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591  (http://support.microsoft.com/kb/119591/ ) How to obtain Microsoft support files from online services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

Cumulative hotfix package for Itanium-based operating systems

If you are running any component of SQL Server 2005 on an Itanium-based operating system, you must install the following package. The following file is available for download from the Microsoft Download Center:

Collapse this imageExpand this image
Download
Download the SQLServer2005-KB933097-IA64-ENU.exe package now. (http://download.microsoft.com/download/7/3/f/73fe973b-5273-433d-adf9-178e670a84bc/SQLServer2005-KB933097-IA64-ENU.exe)

Release Date: March 7, 2007

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591  (http://support.microsoft.com/kb/119591/ ) How to obtain Microsoft support files from online services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

SQL Server 2005 post-SP2 hotfixes that are included in SQL Server 2005 build 9.0.3152

Note Microsoft Knowledge Base articles that discuss these hotfixes will be released as they become available.
Collapse this tableExpand this table
SQL bug numberDescription
50000783When you define the value of the AdminTimeout property and the value of the ServerTimeout property, a profiler trace stops unexpectedly.
50000784When you make a data manipulation language (DML) change to a published table, error 2812 occurs.
50000785When you create a cursor by using an SQL statement that uses the OPTION (RECOMPILE) hint, error 16943 occurs. Error 16943 indicates that the table schema changed. This problem occurs when you retrieve information from the cursor location.
50000786A memory leak exists in the MSOLAP provider (Msolap90.dll).
50000787When you configure the Scheduler component to use a time-out value that is less than 15 milliseconds, you experience high CPU usage.
50000809The LazyWriter process uses lots of CPU resources. This problem occurs on a non-uniform memory access (NUMA)-enabled x64-based server that is running SQL Server 2005 x64 Edition.
50000810When you update a view through a cursor, you cannot make a CSEQUAL request or a TSEQUAL request for rows that are extended by using NULL values.
50000873When you run an application in SQL Server 2005, error 8624 occurs. Error 8624 indicates that the cycle check failed.
50000874When the stored procedure runs outside an explicit transaction, a temporary table in a stored procedure is not cleaned up correctly.
50000889When you run a Microsoft Office Excel data mining operation, you receive the following error message:
The 'MINIMUM_DEPENDENCY_PROBABILITY' data mining parameter is not valid for the 'Table1_283833_NB_413946' model
50000939The Maintenance Cleanup task uses an incorrect age group for cleanup operations.

Cumulative update file information

This cumulative update contains only those files that are required to correct the issues that this article lists. This cumulative update may not contain of all the files that you must have to fully update a product to the latest build.
The English version of this cumulative 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.
SQL Server 2005 Database Engine, 32-bit version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.sqlserver.maintenanceplantasks.dll9.0.3152.0296,30403-Mar-200707:53x86
Msmdlocal.dll9.0.3152.015,930,22403-Mar-200707:53x86
Mssqlsystemresource.ldfNot applicable524,28803-Mar-200705:03Not applicable
Mssqlsystemresource.mdfNot applicable40,173,56803-Mar-200705:03Not applicable
Sqlaccess.dll2005.90.3152.0350,57603-Mar-200707:53x86
Sqlservr.exe2005.90.3152.029,191,02403-Mar-200707:53x86
SQL Server 2005 Analysis Services, 32-bit version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Msmdlocal.dll9.0.3152.015,930,22403-Mar-200707:53x86
Msmdsrv.exe9.0.3152.014,898,54403-Mar-200707:53x86
Msmgdsrv.dll9.0.3152.06,041,45603-Mar-200707:53x86
Msolap90.dll9.0.3152.04,299,12003-Mar-200707:53x86
SQL Server 2005 Reporting Services, 32-bit version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.reportingservices.diagnostics.dll9.0.3152.0800,11203-Mar-200707:53x86
Msmdlocal.dll9.0.3152.015,930,22403-Mar-200707:53x86
Msmgdsrv.dll9.0.3152.06,041,45603-Mar-200707:53x86
Reportingservicesservice.exe9.0.3152.017,26403-Mar-200707:53x86
SQL Server 2005 Notification Services, 32-bit version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Nsservice.exe9.0.3152.021,87203-Mar-200707:53x86
SQL Server 2005 Integration Services, 32-bit version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.sqlserver.maintenanceplantasks.dll9.0.3152.0296,30403-Mar-200707:53x86
Msdtssrvr.exe9.0.3152.0206,19203-Mar-200707:53x86
Msmdlocal.dll9.0.3152.015,930,22403-Mar-200707:53x86
SQL Server 2005 Tools, 32-bit version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.reportingservices.diagnostics.dll9.0.3152.0800,11203-Mar-200707:53x86
Microsoft.sqlserver.maintenanceplantasks.dll9.0.3152.0296,30403-Mar-200707:53x86
Microsoft.sqlserver.maintenanceplantasksui.dll9.0.3152.0722,28803-Mar-200707:53x86
Msmdlocal.dll9.0.3152.015,930,22403-Mar-200707:53x86
Msmgdsrv.dll9.0.3152.06,041,45603-Mar-200707:53x86
Msolap90.dll9.0.3152.04,299,12003-Mar-200707:53x86
Sqlwb.exe2005.90.3152.0824,17603-Mar-200707:53x86
SQL Server 2005 Database Engine, x64-based version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.sqlserver.maintenanceplantasks.dll9.0.3152.0296,30403-Mar-200707:53x86
Msmdlocal.dll9.0.3152.015,930,22403-Mar-200707:53x86
Mssqlsystemresource.ldfNot applicable524,28803-Mar-200705:03Not applicable
Mssqlsystemresource.mdfNot applicable40,173,56803-Mar-200705:03Not applicable
Sqlaccess.dll2005.90.3152.0357,74403-Mar-200712:52x86
Sqlservr.exe2005.90.3152.038,645,61603-Mar-200712:52x64
SQL Server 2005 Analysis Services, x64-based version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Msmdlocal.dll9.0.3152.015,930,22403-Mar-200707:53x86
Msmdlocal.dll9.0.3152.030,801,77603-Mar-200712:52x64
Msmdsrv.exe9.0.3152.030,130,03203-Mar-200712:52x64
Msmgdsrv.dll9.0.3152.06,041,45603-Mar-200707:53x86
Msmgdsrv.dll9.0.3152.09,101,68003-Mar-200712:52x64
Msolap90.dll9.0.3152.04,299,12003-Mar-200707:53x86
Msolap90.dll9.0.3152.05,849,96803-Mar-200712:52x64
SQL Server 2005 Reporting Services, x64-based version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.reportingservices.diagnostics.dll9.0.3152.0800,11203-Mar-200712:52x86
Msmdlocal.dll9.0.3152.030,801,77603-Mar-200712:52x64
Msmgdsrv.dll9.0.3152.09,101,68003-Mar-200712:52x64
Reportingservicesservice.exe9.0.3152.017,26403-Mar-200712:52x86
SQL Server 2005 Notification Services, x64-based version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Nsservice.exe9.0.3152.021,87203-Mar-200712:52x86
SQL Server 2005 Integration Services, x64-based version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.sqlserver.maintenanceplantasks.dll9.0.3152.0296,30403-Mar-200707:53x86
Msdtssrvr.exe9.0.3152.0202,09603-Mar-200712:52x64
Msmdlocal.dll9.0.3152.030,801,77603-Mar-200712:52x64
SQL Server 2005 Tools, x64-based version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.reportingservices.diagnostics.dll9.0.3152.0800,11203-Mar-200707:53x86
Microsoft.sqlserver.maintenanceplantasks.dll9.0.3152.0296,30403-Mar-200707:53x86
Microsoft.sqlserver.maintenanceplantasksui.dll9.0.3152.0722,28803-Mar-200707:53x86
Microsoft.visualstudio.templatewizardinterface.dll8.0.50727.4215,87223-Sep-200506:56x86
Msmdlocal.dll9.0.3152.015,930,22403-Mar-200707:53x86
Msmdlocal.dll9.0.3152.030,801,77603-Mar-200712:52x64
Msmgdsrv.dll9.0.3152.06,041,45603-Mar-200707:53x86
Msmgdsrv.dll9.0.3152.09,101,68003-Mar-200712:52x64
Msolap90.dll9.0.3152.04,299,12003-Mar-200707:53x86
Msolap90.dll9.0.3152.05,849,96803-Mar-200712:52x64
Sqlwb.exe2005.90.3152.0824,17603-Mar-200707:53x86
SQL Server 2005 Database Engine, Itanium architecture version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.sqlserver.maintenanceplantasks.dll9.0.3152.0296,30403-Mar-200707:53x86
Msmdlocal.dll9.0.3152.049,815,92003-Mar-200714:03IA-64
Mssqlsystemresource.ldfNot applicable524,28803-Mar-200705:03Not applicable
Mssqlsystemresource.mdfNot applicable40,173,56803-Mar-200705:03Not applicable
Sqlaccess.dll2005.90.3152.0352,11203-Mar-200714:03x86
Sqlservr.exe2005.90.3152.072,613,74403-Mar-200714:03IA-64
SQL Server 2005 Analysis Services, Itanium architecture version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Msmdlocal.dll9.0.3152.015,930,22403-Mar-200707:53x86
Msmdlocal.dll9.0.3152.049,815,92003-Mar-200714:03IA-64
Msmdsrv.exe9.0.3152.048,766,83203-Mar-200714:03IA-64
Msmgdsrv.dll9.0.3152.06,041,45603-Mar-200707:53x86
Msmgdsrv.dll9.0.3152.013,128,04803-Mar-200714:03IA-64
Msolap90.dll9.0.3152.04,299,12003-Mar-200707:53x86
Msolap90.dll9.0.3152.07,910,25603-Mar-200714:03IA-64
SQL Server 2005 Reporting Services, Itanium architecture version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.reportingservices.diagnostics.dll9.0.3152.0800,11203-Mar-200714:03x86
Msmdlocal.dll9.0.3152.049,815,92003-Mar-200714:03IA-64
Msmgdsrv.dll9.0.3152.013,128,04803-Mar-200714:03IA-64
Reportingservicesservice.exe9.0.3152.017,26403-Mar-200714:03x86
SQL Server 2005 Notification Services, Itanium architecture version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Nsservice.exe9.0.3152.021,87203-Mar-200714:03x86
SQL Server 2005 Integration Services, Itanium architecture version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.sqlserver.maintenanceplantasks.dll9.0.3152.0296,30403-Mar-200707:53x86
Msdtssrvr.exe9.0.3152.0202,09603-Mar-200714:03IA-64
Msmdlocal.dll9.0.3152.049,815,92003-Mar-200714:03IA-64
SQL Server 2005 Tools, Itanium architecture version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.reportingservices.diagnostics.dll9.0.3152.0800,11203-Mar-200707:53x86
Microsoft.sqlserver.maintenanceplantasks.dll9.0.3152.0296,30403-Mar-200707:53x86
Microsoft.sqlserver.maintenanceplantasksui.dll9.0.3152.0722,28803-Mar-200707:53x86
Microsoft.visualstudio.templatewizardinterface.dll8.0.50727.4215,87223-Sep-200506:56x86
Msmdlocal.dll9.0.3152.015,930,22403-Mar-200707:53x86
Msmdlocal.dll9.0.3152.049,815,92003-Mar-200714:03IA-64
Msmgdsrv.dll9.0.3152.06,041,45603-Mar-200707:53x86
Msmgdsrv.dll9.0.3152.013,128,04803-Mar-200714:03IA-64
Msolap90.dll9.0.3152.04,299,12003-Mar-200707:53x86
Msolap90.dll9.0.3152.07,910,25603-Mar-200714:03IA-64
Sqlwb.exe2005.90.3152.0824,17603-Mar-200707:53x86

REFERENCES

For more information about how to obtain SQL Server 2005 Service Pack 2, click the following article number to view the article in the Microsoft Knowledge Base:
913089  (http://support.microsoft.com/kb/913089/ ) How to obtain the latest service pack for SQL Server 2005
For more information about the new features and the improvements in SQL Server 2005 Service Pack 2, visit the following Microsoft Web site:
http://go.microsoft.com/fwlink/?LinkId=71711 (http://go.microsoft.com/fwlink/?LinkId=71711)
For more information about the naming schema for SQL Server updates, click the following article number to view the article in the Microsoft Knowledge Base:
822499  (http://support.microsoft.com/kb/822499/ ) New naming schema for Microsoft SQL Server software update packages

APPLIES TO
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Express Edition
Keywords: 
atdownload kbqfe KB933097
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support