[EN] SQL Server 2008 Service Pack 3 Cumulative Update 6 is available

LOGO__SQLServer2008SP3Another one package with updates for SQL Server 2008 is for SQL Server 2008 with Service Pack 3.  In this post you will find some information about it.

In this Cumulative Update [10.00.5788.00.] Microsoft resolved & fixed not very much issues in components:
* for SQL Server Engine
* for SQL Server Analysis Services
* for SQL Server Reporting Services
* for SQL Server Manageability
* for Parallel Data Warehouse

Below You can find short information about fixed bug:

VSTS BUG: 934425 | 2498839
FIX: A memory error occurs when you perform a full process of a dimension in SSAS 2008 R2 or in SSAS 2008

VSTS BUG: 924224 | 2543687
FIX: Errors when a client application sends an attention signal to SQL Server 2008 or SQL Server 2008 R2

VSTS BUG: 934417 | 2625768
FIX: A database page is copied into a database snapshot even though the page is not updated when you perform a read operation in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 837467 | 2644794
FIX: False assertion error when you try to convert the value from an XML column to an XML variable in SQL Server 2008

VSTS BUG: 958660 | 2645648
FIX: Export procedure fails when you export a 64-bit SSRS 2008 R2 report or a SSRS 2008 report that contains multiple levels of a document map to the PDF format

VSTS BUG: 934429 | 2671078
FIX: “Attempting to set a non-NULL-able column’s value to NULL” error message when you use a MERGE statement in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 934433 | 2673997
FIX: “The index data is damaged” error message when you run an MDX query against a dimension or partition in SSAS 2008, in SSAS 2008 R2 or in SSAS 2012

VSTS BUG: 934421 | 2680799
FIX: Error message when you perform a full population of a full-text index by using word breakers for Chinese language in SQL Server 2008

VSTS BUG: 905391 | 2699013
FIX: SQL Server 2008 R2 or SQL Server 2008 stops responding and a “Non-yielding Scheduler” error is logged

VSTS BUG: 950577 | 2706601
FIX: Series groups in a report are missing when you render the report in SQL Server 2008 Reporting Services or in later versions of Reporting Services

VSTS BUG: 947513 | 2713151
FIX: Access violation when you use Database Engine Tuning Advisor to tune a table in SQL Server 2008 if you enable the “Include filtered indexes” check box

VSTS BUG: 961089 | 2720940
FIX: Corrupted codes are recorded in Application log or Security log when you audit an instance of SQL Server 2008 that is running on an IA-64 computer

VSTS BUG: 966617 | 2723474
FIX: Event ID 322 error even though operations complete successfully in SQL Server 2008

VSTS BUG: 973521 | 2727322
FIX: Incorrect results are returned when you run a query that uses parallelism in the query execution plan in SQL Server 2008

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 6

You may have to restart the computer after you apply this cumulative update.

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.

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

LOGO__SQLServer2008SP2Four days ago (just on 17th July) Microsoft released two packets of Cumulative Updates for SQL Server 2008. In this post I’ll write about SQL Server 2008 with Service Pack 2.

In this Cumulative Update 11 [version build: 10.00.4333.00.] Microsoft resolved & fixed bugs for components:
* for SQL Server Analysis Services
* for SQL Server Manageability

Below You can find short information about fixed bugs:

VSTS BUG: 950904 | 2406666
FIX: “[Teradata Database] [3737]” error message when you click “Count” in the Aggregation Design Wizard in SSAS 2008

VSTS BUG: 966619 | 2723474
FIX: Event ID 322 error even though operations complete successfully in SQL Server 2008

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 11

You may have to restart the computer after you apply this cumulative update.

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.

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

LOGO__SQLServer2008R2Sp1The second one for today’s update packages are for SQL Server 2008 R2 with Service Pack 1. In previous post I wrote about SQL Server 2008 R2 and in next I’m going to write about new SQL Server 2012.

In this Cumulative Update 7 [version build: 10.50.2817.0.] Microsoft resolved & fixed a lot of bugs for five components:
* for SQL Server Engine
* for SQL Server Analysis Services
* for SQL Server Reporting Services
* for SQL Server Manageability
* for SQL Server Connectivity

Below You can find short information about fixed bugs:

VSTS BUG: 801801 | 2618676
FIX: Transaction log backup is created even though the full backup is canceled in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 934419 | 2625768
FIX: A database page is copied into a database snapshot even though the page is not updated when you perform a read operation in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 898890 | 2658474
FIX: Incorrect results when the SqlConnection.GetSchema method retrieves a table’s schema information in SQL Server 2008, in SQL Server 2008 R2, or in SQL Server 2012

VSTS BUG: 860526 | 2661644
FIX: Access violation might occur in the sqlservr!ReplicaToPrimaryPageCopier::ReadIoCompletionRoutine function in SQL Server 2008 R2

VSTS BUG: 867697 | 2667037
FIX: “The connection string format is not valid” error when you try to create a maintenance plan for a SQL Server 2008 R2 server

VSTS BUG:  934435 | 2673997
FIX: “The index data is damaged” error message when you run an MDX query against a dimension or partition in SSAS 2008, in SSAS 2008 R2, or in SSAS 2012

VSTS BUG: 919031 | 2674636
FIX: The size of a database file is not reduced when you use the DBCC SHRINKFILE command in SQL Server 2008 R2

VSTS BUG: 919029 | 696161
FIX: Error message when you try to view a report in SSRS 2008 R2: “Different query parameters resulted in a same hash”

VSTS BUG: 905366 | 697983
FIX: An incorrect value is stored in the TIME_ZONE column of the BACKUPSET table in SQL Server 2008 R2

VSTS BUG: 905383 | 2699013
FIX: SQL Server 2008 R2 stops responding and a “Non-yielding Scheduler” error is logged

VSTS BUG: 921060 | 2703152
FIX: Access violation when you call a CLR stored procedure that references a user-defined table type parameter in SQL Server 2012 or in SQL Server 2008 R2

VSTS BUG: 924055 | 2703214
FIX: SQL Server 2008 R2 may not accept the client connection request when you perform a bulk insert, and an OS error occurs

VSTS BUG: 952564 | 2706518
FIX: The KeepFilesForDays setting does not work in SQL Server 2008 or in SQL Server 2008 R2 Reporting Services

VSTS BUG: 928501 | 2706519
FIX: An exception occurs when the SqlCommandBuilder.DeriveParameters method is used to retrieve parameter information from a CLR stored procedure in SQL Server 2008 R2

VSTS BUG: 928854| 2706601
FIX: Series groups in a report are missing when you display the report in SQL Server 2008 Reporting Services or in later versions of Reporting Services

VSTS BUG: 929551 | 2707015
FIX: rsInternalError error when you export a report that contains a Tablix control in SSRS 2008 R2

VSTS BUG: 930436 | 2708027
FIX: “An error has occurred during report processing” error message when you try to preview an SSRS 2008 R2 report after you set the dataset collation to Greek or Greek_100

VSTS BUG: 931133 | 2708726
FIX: The Agent perfmon DLL files in the system32 folder are not updated as expected after you apply new updates for SQL Server 2008 R2

VSTS BUG: 934250 | 2711549
FIX: “Non-yielding IOCP Listener” error message when you start SQL Server 2008 R2 or a client sends a request to the SQL Server 2008 R2

VSTS BUG: 948176 | 2713501
FIX: A deadlock occurs when you alter a partition and run a statement against the partition at the same time in SQL Server 2008 R2

VSTS BUG: 950155 | 2714634
FIX: SQL Server 2008 R2 takes a long time to generate scripts for the table that uses data compression

VSTS BUG: 951083 | 2715289
FIX: Incorrect results when you convert a datetimeoffset column to a smalldatetime column in SQL Server 2008 R2 when there is an index on the datetimeoffset column

VSTS BUG: 951029 | 2715312
FIX: Errors when you run a query that uses the FOR XML clause in the PATH mode in SQL Server 2008 R2

VSTS BUG: 868175 |  2722165
FIX: The restore behavior does not stop at the time that you defined in SQL Server 2008 R2

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

You may have to restart the computer after you apply this cumulative update.

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.