Cumulative update package 9 for SQL Server 2005 Service Pack 2

INTRODUCTION

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

Cumulative Update 9 contains hotfixes for SQL Server 2005 issues that have been fixed since the release of Service Pack 2.

Note This build of the cumulative update package is also known as build 3282.

We recommend that you test hotfixes before you deploy them in a production environment. Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2005 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

937137 (https://support.microsoft.com/kb/937137/) The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released

Back to the top

Important notes about the cumulative update package

SQL Server 2005 hotfixes are now Multilanguage. Therefore, there is only one cumulative hotfix package for all languages.

One cumulative hotfix package includes all the component packages. The cumulative update package updates 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 apply the cumulative update 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).

 

https://support.microsoft.com/kb/953752/