Cumulative Update packages for SQL Server 2008 are available now: CU7 for SQL2008 SP2 and CU2 for SQL2008 SP3
Another instalment of Cumulative Update package for SQL Server 2008 SP3 is available now, which is CU2 and the build number is known as 10.00.5768.00.
As usual this CU2 for SQL2008 SP3 contains hotfixes for issues that were fixed after the release of SQL Server 2008 Service Pack 3 (SP3).
KBA2633143 list the following article numbers about more information on the fixes:
| VSTS bug number |
KB article number |
Description |
| 794387 |
2522893 (http://support.microsoft.com/kb/2522893/ ) |
FIX: A backup operation on a SQL Server 2008 or SQL Server 2008 R2 database fails if you enable change tracking on this database |
| 816523 |
2536225 (http://support.microsoft.com/kb/2536225/ ) |
FIX: CLR stored procedure returns NULL after it is recompiled in SQL Server 2008 R2 |
| 831263 |
How to obtain this cumulative update package
loadTOCNode(2, 'moreinformation'); A supported cumulative update package is now available from Microsoft. However, it is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems. This cumulative update package may receive additional testing. Therefore, if you are not severely affected by any of these problems, we recommend that you wait for the next SQL Server 2008 service pack that contains the hotfixes in this cumulative update package.
If the cumulative update is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.
Note If additional issues occur or any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific cumulative update package. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft website: http://support.microsoft.com/contactus/?ws=support link.
___________________________________________________________________________________________________________________________________________________
The next instalment of Cumulative Update package for SQL Server 2008 Service Pack 2 is availabel for download, the build number for this CU7 will be 10.00.4323.
Further the cumulative update package includes updates for all the component packages. However, a cumulative update package updates only those components that are installed on a system. You cannot apply this CU7 straight away, the pre-requisite is SQL 2008 SP2. Here is the big list of bugs and issues fixed with this CU7 for SQL2008 SP2:
| VSTS bug number |
KB article number |
Description |
| 799306 |
2515286 (http://support.microsoft.com/kb/2515286/ ) |
FIX: "There is no function '{urn:schemas-microsoft-com:xml-sql}:variable()" error for an XQuery query that updates the value of an XML column in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 |
| 806150 |
2531172 (http://support.microsoft.com/kb/2531172/ ) |
FIX: "Unable to obtain the current member" error when you run an MDX query in SQL Server 2008 R2 Analysis Services |
| 799294 |
2583994 (http://support.microsoft.com/kb/2583994/ ) |
FIX: SSIS Checkpoint restores an incorrect variable value for an Execute SQL Task item of a For Loop Container item in SSIS 2008 if an SSIS package executes again after it fails or stops |
| 776912 |
2588506 (http://support.microsoft.com/kb/2588506/ ) |
FIX: SQLGetDiagRec function does not return errors in SQL Server 2008 R2 if more than 2100 query parameters are sent |
| 799291 |
2591461 (http://support.microsoft.com/kb/2591461/ ) |
FIX: "Unexpected error from SE OLEDB interface" error when you run a full-text search query in SQL Server 2008 |
| 799303 |
2598903 (http://support.microsoft.com/kb/2598903/ ) |
FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005 or in SQL Server 2008 |
| 788324 |
2603910 (http://support.microsoft.com/kb/2603910/ ) |
FIX: Backup fails in SQL Server 2008 or in SQL Server 2008 R2 if you enable change tracking on the database |
| 801804 |
2618676 (http://support.microsoft.com/kb/2618676/ ) |
FIX: Transaction log backup is created even though no valid full backup exists in SQL Server 2008 |
| 801802 |
2618680 (http://support.microsoft.com/kb/2618680/ ) |
FIX: "Not registered correctly" error when you use a pull subscription and the Replication Interactive Conflict Resolver |
| 804390 |
2619077 (http://support.microsoft.com/kb/2619077/ ) |
FIX: Access violation when a request reads a missing index in SQL Server 2008 |
| 801134 |
2625989 (http://support.microsoft.com/kb/2625989/ ) |
"Cannot download the information you requested" error in SSRS 2008 when you click a drillthrough report link |
| 814972 |
2628126 (http://support.microsoft.com/kb/2628126/ ) |
FIX: "Fulltext index error during compression or decompression" error when you create a full-text index in SQL Server 2008 if the primary key is set to a BIGINT column |
| 823528 |
2635540 (http://support.microsoft.com/kb/2635540/ ) |
FIX: Error message when you use a catalog database whose name contains some special characters in SSRS 2008 |
| 823667 |
2635827 (http://support.microsoft.com/kb/2635827/ ) |
FIX: Access violation when you run a DBCC CHECKDB command against a database that contains a table that has a spatial index in SQL Server 2008 |
| 817085 |
2638448 (http://support.microsoft.com/kb/2638448/ ) |
FIX: Access violation when a query is compiled in SQL Server 2008 |
| 819357 |
2638932 (http://support.microsoft.com/kb/2638932/ ) |
FIX: Error when you run the ProcessUpdate command against a cube that has partitions that use aggregation designs in SSAS 2008 |
| 823699 |
2640110 (http://support.microsoft.com/kb/2640110/ ) |
FIX: An sp_execute_policy error if both SQL Server 2008 R2 and SQL Server 2008 are installed |
| 806841 |
2643872 (http://support.microsoft.com/kb/2643872/ ) |
FIX: "HRESULT 0xE06D7363" error when a client application uses Microsoft.SqlServer.Types.dll component on a computer that has SQL Server 2008 SP2 installed |
Also the list of CU packages for your information:
Further I also recommend to know about new naming schema for these software update packages from KBA822499 and information about Incremental Servicing Model from this KBA935897 link. Don't forget to test the CU package before applying it on production.
