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.
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:
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.
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:
For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
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:
For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
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:
For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
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 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
Collapse this tableExpand this table
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
Collapse this tableExpand this table
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
Collapse this tableExpand this table
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
Collapse this tableExpand this table
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
Collapse this tableExpand this table
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
Collapse this tableExpand this table
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
Collapse this tableExpand this table
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
Collapse this tableExpand this table
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
Collapse this tableExpand this table
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
Collapse this tableExpand this table
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
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:
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:
Back to the top
