Microsoft SQL Server 2005 hotfixes are created for specific SQL Server service packs. You must apply a SQL Server 2005 Service Pack 3 hotfix to an installation of SQL Server 2005 Service Pack 3. By default, any hotfix that is provided in a SQL Server service pack is included in the next SQL Server service pack.
Cumulative Update 1 for SQL Server 2005 Service Pack 3 (SP3) contains only hotfixes that were released in Cumulative Update 10 for SQL Server 2005 Service Pack 2 (SP2) and Cumulative Update 11 for SQL Server 2005 Service Pack 2 (SP2). These hotfixes are not included in SQL Server 2005 Service Pack 3. Cumulative Update 1 for SQL 2005 SP3 is only intended as a post-service pack rollup for Cumulative Update 10 for SQL Server 2005 SP2 and Cumulative Update 11 for SQL Server 2005 SP2 customers who plan to upgrade to SQL Server 2005 SP3 and still keep the hotfixes from Cumulative Update 10 for SQL Server 2005 SP2 and Cumulative Update 11 for SQL Server 2005 SP2. No new hotfixes have been included in this cumulative update other than the hotfixes that were already released in Cumulative Update 10 and Cumulative Update 11.
Note
This build of the cumulative update package is also known as build 9.00.4207.
Cumulative Update 1 for SQL Server 2005 Service Pack 3 (SP3) contains only hotfixes that were released in Cumulative Update 10 for SQL Server 2005 Service Pack 2 (SP2) and Cumulative Update 11 for SQL Server 2005 Service Pack 2 (SP2). These hotfixes are not included in SQL Server 2005 Service Pack 3. Cumulative Update 1 for SQL 2005 SP3 is only intended as a post-service pack rollup for Cumulative Update 10 for SQL Server 2005 SP2 and Cumulative Update 11 for SQL Server 2005 SP2 customers who plan to upgrade to SQL Server 2005 SP3 and still keep the hotfixes from Cumulative Update 10 for SQL Server 2005 SP2 and Cumulative Update 11 for SQL Server 2005 SP2. No new hotfixes have been included in this cumulative update other than the hotfixes that were already released in Cumulative Update 10 and Cumulative Update 11.
Note
This build of the cumulative update package is also known as build 9.00.4207.
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).