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:
- Click Start, click Control Panel, and then click Add or Remove Programs.
- In Add or Remove Programs, click Change or Remove Programs.
- To see all the updates for the SQL Server 2005 installation, click to select the Show Updates check box.
- 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]](/wiki/index.php?title=File:Download.gif){kind=small}
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:
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:
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: |
| 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
