[EN] SQL Server 2008 Service Pack 2 Cumulative Update 7 is available

LOGO__sql_server_2008The second one from today’s cumulative updates is for SQL Server 2008 too. But this time its for a little bit earlier version (for SP2).

In this Cumulative Update 9 [version build: 10.00.4323.0.] Microsoft resolves & fixed not very much, but not too much bugs for six components:
* for SQL Server Engine
* for SQL Server Analysis Services
* for SQL Server Manageability
* for SQL Server Reporting Services
* for SQL Server Connectivity
* for SQL Server Integration Services

Below You can find short information about fixed bugs:

VSTS BUG: 799306 | 515286
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

VSTS BUG: 806150 | 531172
FIX: “Unable to obtain the current member” error when you run an MDX query in SQL Server 2008 R2 Analysis Services

VSTS BUG: 799294 | 583994
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

VSTS BUG: 776912 | 588506
FIX: SQLGetDiagRec function does not return errors in SQL Server 2008 R2 if more than 2100 query parameters are sent

VSTS BUG: 799291 | 2591461
FIX: “Unexpected error from SE OLEDB interface” error when you run a full-text search query in SQL Server 2008

VSTS BUG: 799303 | 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

VSTS BUG: 788324 | 2603910
FIX: Backup fails in SQL Server 2008 or in SQL Server 2008 R2 if you enable change tracking on the database

VSTS BUG: 801804 | 2618676
FIX: Transaction log backup is created even though no valid full backup exists in SQL Server 2008

VSTS BUG: 801802 |  2618680
FIX: “Not registered correctly” error when you use a pull subscription and the Replication Interactive Conflict Resolver

VSTS BUG: 804390 | 2619077
FIX: Access violation when a request reads a missing index in SQL Server 2008

VSTS BUG: 801134 | 2625989
FIX: “Cannot download the information you requested” error in SSRS 2008 when you click a drillthrough report link

VSTS BUG: 814972 | 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

VSTS BUG: 823528 | 2635540
FIX: Error message when you use a catalog database whose name contains some special characters in SSRS 2008

VSTS BUG: 823667 | 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

VSTS BUG: 817085 | 2638448
FIX: Access violation when a query is compiled in SQL Server 2008

VSTS BUG: 819357 | 2638932
FIX: Error when you run the ProcessUpdate command against a cube that has partitions that use aggregation designs in SSAS 2008

VSTS BUG: 823699 | 2640110
FIX: An sp_execute_policy error if both SQL Server 2008 R2 and SQL Server 2008 are installed

VSTS BUG: 806841 | 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

Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 7

If You want to go directly to download section jump to Request Hotfix Download Site, where You can choose version (for 32-bit, 64-bit, itanium). This release is prepared as multilingual package.