Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

November 2011 - Posts - SQL Server Knowledge Sharing Network (@sqlmaster)

November 2011 - Posts

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

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.