Microsoft KB Archive/933097

From BetaArchive Wiki
Knowledge Base


Contents

Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available

Article ID: 933097

Article Last Modified on 11/20/2007



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



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.

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 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:

[GRAPHIC: Download]Download the SQLServer2005-KB933097-x86-ENU.exe package now.

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 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:

[GRAPHIC: Download]Download the SQLServer2005-KB933097x64-ENU.exe package now.

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 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:

[GRAPHIC: Download]Download the SQLServer2005-KB933097-IA64-ENU.exe package now.

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 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.

SQL bug number Description
50000783 When you define the value of the AdminTimeout property and the value of the ServerTimeout property, a profiler trace stops unexpectedly.
50000784 When you make a data manipulation language (DML) change to a published table, error 2812 occurs.
50000785 When 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.
50000786 A memory leak exists in the MSOLAP provider (Msolap90.dll).
50000787 When you configure the Scheduler component to use a time-out value that is less than 15 milliseconds, you experience high CPU usage.
50000809 The 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.
50000810 When 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.
50000873 When you run an application in SQL Server 2005, error 8624 occurs. Error 8624 indicates that the cycle check failed.
50000874 When the stored procedure runs outside an explicit transaction, a temporary table in a stored procedure is not cleaned up correctly.
50000889

When 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

50000939 The 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
File name File version File size Date Time Platform
Microsoft.sqlserver.maintenanceplantasks.dll 9.0.3152.0 296,304 03-Mar-2007 07:53 x86
Msmdlocal.dll 9.0.3152.0 15,930,224 03-Mar-2007 07:53 x86
Mssqlsystemresource.ldf Not applicable 524,288 03-Mar-2007 05:03 Not applicable
Mssqlsystemresource.mdf Not applicable 40,173,568 03-Mar-2007 05:03 Not applicable
Sqlaccess.dll 2005.90.3152.0 350,576 03-Mar-2007 07:53 x86
Sqlservr.exe 2005.90.3152.0 29,191,024 03-Mar-2007 07:53 x86
SQL Server 2005 Analysis Services, 32-bit version
File name File version File size Date Time Platform
Msmdlocal.dll 9.0.3152.0 15,930,224 03-Mar-2007 07:53 x86
Msmdsrv.exe 9.0.3152.0 14,898,544 03-Mar-2007 07:53 x86
Msmgdsrv.dll 9.0.3152.0 6,041,456 03-Mar-2007 07:53 x86
Msolap90.dll 9.0.3152.0 4,299,120 03-Mar-2007 07:53 x86
SQL Server 2005 Reporting Services, 32-bit version
File name File version File size Date Time Platform
Microsoft.reportingservices.diagnostics.dll 9.0.3152.0 800,112 03-Mar-2007 07:53 x86
Msmdlocal.dll 9.0.3152.0 15,930,224 03-Mar-2007 07:53 x86
Msmgdsrv.dll 9.0.3152.0 6,041,456 03-Mar-2007 07:53 x86
Reportingservicesservice.exe 9.0.3152.0 17,264 03-Mar-2007 07:53 x86
SQL Server 2005 Notification Services, 32-bit version
File name File version File size Date Time Platform
Nsservice.exe 9.0.3152.0 21,872 03-Mar-2007 07:53 x86
SQL Server 2005 Integration Services, 32-bit version
File name File version File size Date Time Platform
Microsoft.sqlserver.maintenanceplantasks.dll 9.0.3152.0 296,304 03-Mar-2007 07:53 x86
Msdtssrvr.exe 9.0.3152.0 206,192 03-Mar-2007 07:53 x86
Msmdlocal.dll 9.0.3152.0 15,930,224 03-Mar-2007 07:53 x86
SQL Server 2005 Tools, 32-bit version
File name File version File size Date Time Platform
Microsoft.reportingservices.diagnostics.dll 9.0.3152.0 800,112 03-Mar-2007 07:53 x86
Microsoft.sqlserver.maintenanceplantasks.dll 9.0.3152.0 296,304 03-Mar-2007 07:53 x86
Microsoft.sqlserver.maintenanceplantasksui.dll 9.0.3152.0 722,288 03-Mar-2007 07:53 x86
Msmdlocal.dll 9.0.3152.0 15,930,224 03-Mar-2007 07:53 x86
Msmgdsrv.dll 9.0.3152.0 6,041,456 03-Mar-2007 07:53 x86
Msolap90.dll 9.0.3152.0 4,299,120 03-Mar-2007 07:53 x86
Sqlwb.exe 2005.90.3152.0 824,176 03-Mar-2007 07:53 x86
SQL Server 2005 Database Engine, x64-based version
File name File version File size Date Time Platform
Microsoft.sqlserver.maintenanceplantasks.dll 9.0.3152.0 296,304 03-Mar-2007 07:53 x86
Msmdlocal.dll 9.0.3152.0 15,930,224 03-Mar-2007 07:53 x86
Mssqlsystemresource.ldf Not applicable 524,288 03-Mar-2007 05:03 Not applicable
Mssqlsystemresource.mdf Not applicable 40,173,568 03-Mar-2007 05:03 Not applicable
Sqlaccess.dll 2005.90.3152.0 357,744 03-Mar-2007 12:52 x86
Sqlservr.exe 2005.90.3152.0 38,645,616 03-Mar-2007 12:52 x64
SQL Server 2005 Analysis Services, x64-based version
File name File version File size Date Time Platform
Msmdlocal.dll 9.0.3152.0 15,930,224 03-Mar-2007 07:53 x86
Msmdlocal.dll 9.0.3152.0 30,801,776 03-Mar-2007 12:52 x64
Msmdsrv.exe 9.0.3152.0 30,130,032 03-Mar-2007 12:52 x64
Msmgdsrv.dll 9.0.3152.0 6,041,456 03-Mar-2007 07:53 x86
Msmgdsrv.dll 9.0.3152.0 9,101,680 03-Mar-2007 12:52 x64
Msolap90.dll 9.0.3152.0 4,299,120 03-Mar-2007 07:53 x86
Msolap90.dll 9.0.3152.0 5,849,968 03-Mar-2007 12:52 x64
SQL Server 2005 Reporting Services, x64-based version
File name File version File size Date Time Platform
Microsoft.reportingservices.diagnostics.dll 9.0.3152.0 800,112 03-Mar-2007 12:52 x86
Msmdlocal.dll 9.0.3152.0 30,801,776 03-Mar-2007 12:52 x64
Msmgdsrv.dll 9.0.3152.0 9,101,680 03-Mar-2007 12:52 x64
Reportingservicesservice.exe 9.0.3152.0 17,264 03-Mar-2007 12:52 x86
SQL Server 2005 Notification Services, x64-based version
File name File version File size Date Time Platform
Nsservice.exe 9.0.3152.0 21,872 03-Mar-2007 12:52 x86
SQL Server 2005 Integration Services, x64-based version
File name File version File size Date Time Platform
Microsoft.sqlserver.maintenanceplantasks.dll 9.0.3152.0 296,304 03-Mar-2007 07:53 x86
Msdtssrvr.exe 9.0.3152.0 202,096 03-Mar-2007 12:52 x64
Msmdlocal.dll 9.0.3152.0 30,801,776 03-Mar-2007 12:52 x64
SQL Server 2005 Tools, x64-based version
File name File version File size Date Time Platform
Microsoft.reportingservices.diagnostics.dll 9.0.3152.0 800,112 03-Mar-2007 07:53 x86
Microsoft.sqlserver.maintenanceplantasks.dll 9.0.3152.0 296,304 03-Mar-2007 07:53 x86
Microsoft.sqlserver.maintenanceplantasksui.dll 9.0.3152.0 722,288 03-Mar-2007 07:53 x86
Microsoft.visualstudio.templatewizardinterface.dll 8.0.50727.42 15,872 23-Sep-2005 06:56 x86
Msmdlocal.dll 9.0.3152.0 15,930,224 03-Mar-2007 07:53 x86
Msmdlocal.dll 9.0.3152.0 30,801,776 03-Mar-2007 12:52 x64
Msmgdsrv.dll 9.0.3152.0 6,041,456 03-Mar-2007 07:53 x86
Msmgdsrv.dll 9.0.3152.0 9,101,680 03-Mar-2007 12:52 x64
Msolap90.dll 9.0.3152.0 4,299,120 03-Mar-2007 07:53 x86
Msolap90.dll 9.0.3152.0 5,849,968 03-Mar-2007 12:52 x64
Sqlwb.exe 2005.90.3152.0 824,176 03-Mar-2007 07:53 x86
SQL Server 2005 Database Engine, Itanium architecture version
File name File version File size Date Time Platform
Microsoft.sqlserver.maintenanceplantasks.dll 9.0.3152.0 296,304 03-Mar-2007 07:53 x86
Msmdlocal.dll 9.0.3152.0 49,815,920 03-Mar-2007 14:03 IA-64
Mssqlsystemresource.ldf Not applicable 524,288 03-Mar-2007 05:03 Not applicable
Mssqlsystemresource.mdf Not applicable 40,173,568 03-Mar-2007 05:03 Not applicable
Sqlaccess.dll 2005.90.3152.0 352,112 03-Mar-2007 14:03 x86
Sqlservr.exe 2005.90.3152.0 72,613,744 03-Mar-2007 14:03 IA-64
SQL Server 2005 Analysis Services, Itanium architecture version
File name File version File size Date Time Platform
Msmdlocal.dll 9.0.3152.0 15,930,224 03-Mar-2007 07:53 x86
Msmdlocal.dll 9.0.3152.0 49,815,920 03-Mar-2007 14:03 IA-64
Msmdsrv.exe 9.0.3152.0 48,766,832 03-Mar-2007 14:03 IA-64
Msmgdsrv.dll 9.0.3152.0 6,041,456 03-Mar-2007 07:53 x86
Msmgdsrv.dll 9.0.3152.0 13,128,048 03-Mar-2007 14:03 IA-64
Msolap90.dll 9.0.3152.0 4,299,120 03-Mar-2007 07:53 x86
Msolap90.dll 9.0.3152.0 7,910,256 03-Mar-2007 14:03 IA-64
SQL Server 2005 Reporting Services, Itanium architecture version
File name File version File size Date Time Platform
Microsoft.reportingservices.diagnostics.dll 9.0.3152.0 800,112 03-Mar-2007 14:03 x86
Msmdlocal.dll 9.0.3152.0 49,815,920 03-Mar-2007 14:03 IA-64
Msmgdsrv.dll 9.0.3152.0 13,128,048 03-Mar-2007 14:03 IA-64
Reportingservicesservice.exe 9.0.3152.0 17,264 03-Mar-2007 14:03 x86
SQL Server 2005 Notification Services, Itanium architecture version
File name File version File size Date Time Platform
Nsservice.exe 9.0.3152.0 21,872 03-Mar-2007 14:03 x86
SQL Server 2005 Integration Services, Itanium architecture version
File name File version File size Date Time Platform
Microsoft.sqlserver.maintenanceplantasks.dll 9.0.3152.0 296,304 03-Mar-2007 07:53 x86
Msdtssrvr.exe 9.0.3152.0 202,096 03-Mar-2007 14:03 IA-64
Msmdlocal.dll 9.0.3152.0 49,815,920 03-Mar-2007 14:03 IA-64
SQL Server 2005 Tools, Itanium architecture version
File name File version File size Date Time Platform
Microsoft.reportingservices.diagnostics.dll 9.0.3152.0 800,112 03-Mar-2007 07:53 x86
Microsoft.sqlserver.maintenanceplantasks.dll 9.0.3152.0 296,304 03-Mar-2007 07:53 x86
Microsoft.sqlserver.maintenanceplantasksui.dll 9.0.3152.0 722,288 03-Mar-2007 07:53 x86
Microsoft.visualstudio.templatewizardinterface.dll 8.0.50727.42 15,872 23-Sep-2005 06:56 x86
Msmdlocal.dll 9.0.3152.0 15,930,224 03-Mar-2007 07:53 x86
Msmdlocal.dll 9.0.3152.0 49,815,920 03-Mar-2007 14:03 IA-64
Msmgdsrv.dll 9.0.3152.0 6,041,456 03-Mar-2007 07:53 x86
Msmgdsrv.dll 9.0.3152.0 13,128,048 03-Mar-2007 14:03 IA-64
Msolap90.dll 9.0.3152.0 4,299,120 03-Mar-2007 07:53 x86
Msolap90.dll 9.0.3152.0 7,910,256 03-Mar-2007 14:03 IA-64
Sqlwb.exe 2005.90.3152.0 824,176 03-Mar-2007 07:53 x86


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 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:

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 New naming schema for Microsoft SQL Server software update packages



Additional query words: cumulative rollup

Keywords: kbqfe kbpubtypekc atdownload kbhotfixserver KB933097