[EN] SQL Server 2008 SP2 Cumulative Update 3 is now available

LOGO_SQLServer2008Today Microsoft released a series of updates for SQL Server. In last three posts I wrote about updates for SQL Server 2005 ans SQL Server 2008. This is the last of series and it’s about SQL Server 2008.

Cumulative update package no. 3 for SQL Server 2008 SP 2 [version build: 10.00.4279.00] fixed in thirty three issues in total:
* sixteen issues for SQL Server Engine
* four issues for SQL Server Analysis Services
* four issues for SQL Server Manageability
* four issues for SQL Server Reporting Services
* two issues for SQL Server Connectivity
* two issues for SQL Server Integration Services
* one issue for SQL Server Deployment Platform

Below You can find short information about fixed bugs:

VSTS BUG: 650633 | KB Article: 975951
FIX: You receive an error message when you set up a SQL Server 2008 failover cluster on a subnet that contains only IPv6 addresses

VSTS BUG: 649231| KB Article: 2142496
FIX: A SQL Server 2008 R2 or SQL Server 2008 Integration Services package does not run in SQL Server Business Intelligence Development Studio when you use a shared SQL configuration table

VSTS BUG: 661286| KB Article: 2163958
FIX: The SQL Server Utility dashboard may report incorrect CPU usage on DAC databases in SQL Server 2008 R2

VSTS BUG: 621226 | KB Article: 2401548
FIX: An embedded image of a report is incorrectly displayed as a red cross in SQL Server 2008 Reporting Services and in SQL Server 2008 R2 Reporting Services

VSTS BUG: 642792 | KB Article: 2403218
FIX: Database mirroring session is suspended in SQL Server 2005 and in SQL Server 2008 and in SQL Server 2008 R2 if the High-performance (asynchronous) mode is used

VSTS BUG: 648779 | KB Article: 2445812
FIX: A column that uses the DATETIME data type does not replicate to an Oracle subscriber by using a transactional replication in SQL Server 2008

VSTS BUG: 642078| KB Article: 2451540
FIX: Poor performance may occur when you execute a query that contains multiple self-join operations on the same column in SQL Server 2005, in SQL Server 2008 and in SQL Server 2008 R2

VSTS BUG: 650630 | KB Article: 2455614
FIX: BIDS for SQL Server 2008 or SQL Server 2008 R2 responds very slowly when you design an MDX query that has many query parameters

VSTS BUG: 650619 | KB Article: 2459027
FIX: "Index was outside the bounds of the array" SMO error message when you connect to a SQL Server code-named ‘Denali’ CTP1 Database Engine instance in SSMS 2008 R2 and in SSMS 2008

VSTS BUG: 649217 | KB Article: 2478032
FIX: 0xC002F325 error when you run two SSIS 2008 packages at the same time in SQL Server 2008 Integration Services or in SQL Server 2008 R2 Integration Services

VSTS BUG: 654637 | KB Article: 2478514
FIX: The Merge Agent stops with an error message and rows with the genstatus column set to 4 in the msmerge_genhistory system table: "The merge process could not access row data"

VSTS BUG: 648030 | KB Article: 2480368
FIX: SSAS 2008 or SSAS 2008 R2 crashes after a ProcessFull operation is performed on a measure group for a server-based cube if SSAS tries to clean a session that contains a session cube

VSTS BUG: 648038 | KB Article: 2481245
FIX: PivotTable report might return no values after you apply a complex filter in SSAS 2008 or in SSAS 2008 R2

VSTS BUG: 671186 | KB Article: 2481274
FIX: A query that uses the DATEDIFF function may run slowly in SQL Server 2005 or in SQL Server 2008

VSTS BUG: 649223 | KB Article: 2482977
FIX: 10061 Winsock error code occurs when an application uses the extended OLE DB initialization properties for the SQL Server Native Client 10.0 OLE DB provider in the connection string

VSTS BUG: 649227 | KB Article: 2484392
FIX: "xact_seqno" column in the "MSrepl_errors" table does not record a skipped row in SQL Server 2008 if you use the "-SkipErrors" parameter in the Distribution Agent

VSTS BUG: 669146 | KB Article: 2489667
FIX: SQL Server Agent job runs incorrectly if it is scheduled to run every hour on the last day of every week or month in SQL Server 2005 or in SQL Server 2008

VSTS BUG: 671189 | KB Article: 2490920
FIX: "Msg 2601, Level 14, State 1, Line 1 Cannot insert duplicate key row" error when you run the ALTER PARTITION FUNCTION statement to split or merge a partition range in SQL Server 2005 or in SQL Server 2008

VSTS BUG: 649221 | KB Article: 2491210
FIX: Maintenance plan does not back up a database that is set to AUTO_CLOSE, RESTORING, or STANDBY in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 642835 | KB Article: 2497585
FIX: Incorrect newsletter-style report when a text box value extends from one column to another in SSRS 2008 if you use hard-page-break renderer format

VSTS BUG: 651086 | KB Article: 2498818
FIX: Error 7359 when you run a query against a user-defined function or a view that uses a synonym on a linked server in SQL Server 2005 or SQL Server 2008

VSTS BUG: 660073 | KB Article: 2506795
FIX: "Insufficient data for an Image" error when you open a .pdf file that is exported from a SQL Server 2008 Reporting Services environment

VSTS BUG: 668229 | KB Article: 2509659
FIX: The dbo schema is preappended when you use a custom stored procedure in the sp_addarticle stored procedure

VSTS BUG: 669441 | KB Article: 2510668
FIX: You can now use Package Installation Wizard (Dtsinstall.exe) to run the deployment manifest file of an SSIS package when SSIS 2008 is not installed

VSTS BUG: 672739 | KB Article: 2511963
FIX: SQL Server 2008 stops responding when you alter or stop an Extended Events session

 

Microsoft has recommended to test all hotfixes before updating in production environment. This release required installed Service Pack 2 for SQL Server 2008 (available HERE) before starting installation process. And the restart of system (physical or virtual computer; not only SQL Server instance) could be required.

More information about this release You can find with the article: Cumulative Update 3 for SQL Server 2008 Service Pack 2

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 SP1 Cumulative Update 13 is now available

LOGO_SQLServer2008Today Microsoft released a series of updates for SQL Server. In last two posts I wrote about updates for SQL Server 2005. In this and next one  I’ll write about SQL Server 2008. 

Cumulative update package no. 13 for SQL Server 2008 SP 1 [version build: 10.00.2816.00] fixed seventeen issues in total:
* fifteen issues for SQL Server Engine
* one issue for SQL Server Connectivity
* one issue for SQL Server Integration Services

Below You can find short information about fixed bugs:

VSTS BUG: 283855| KB Article: 968215
FIX: Error message when you try to bulk insert data into a table that contains a DATE type column that uses a US date format in SQL Server 2008: "Bulk load data conversion error"

VSTS BUG: 651594| KB Article: 2159286
FIX: The Remote Registry service crashes when an application tries to retrieve performance counter data from an instance of SQL Server on another computer

VSTS BUG: 642791| KB Article: 2403218 
FIX: Database mirroring session is suspended in SQL Server 2005 and in SQL Server 2008 and in SQL Server 2008 R2 if the High-performance (asynchronous) mode is used

VSTS BUG: 621914| KB Article: 2435404
FIX: Computer stops responding when you create a database that contains a FILESTREAM filegroup in SQL Server 2008 or in SQL Server 2008 R2 if a third-party mini-filter driver is installed

VSTS BUG: 654994| KB Article: 2476322
FIX: A common table expression based query that uses the CHANGETABLE function runs very slow in SQL Server 2008 Service Pack 1

VSTS BUG: 671184| KB Article: 2481274
FIX: A query that uses the DATEDIFF function may run slowly in SQL Server 2005 or in SQL Server 2008

VSTS BUG: 669145| KB Article: 2489667
FIX: SQL Server Agent job runs incorrectly if it is scheduled to run every hour on the last day of every week or month in SQL Server 2005 or in SQL Server 2008

VSTS BUG: 671188| KB Article: 2490920
FIX: "Msg 2601, Level 14, State 1, Line 1 Cannot insert duplicate key row" error when you run the ALTER PARTITION FUNCTION statement to split or merge a partition range in SQL Server 2005 or in SQL Server 2008

VSTS BUG: 644445| KB Article: 2491510
FIX: A query that has a CONTAINS predicate in a WHERE clause takes a long time to compile in SQL Server 2008

VSTS BUG: 652184| KB Article:2498818
FIX: Error 7359 when you run a query against a user-defined function or a view that uses a synonym on a linked server in SQL Server 2005 or SQL Server 2008

VSTS BUG: 668752| KB Article: 2519358
FIX: "The integer value is out of range" error when you pass a bigint value as the last_sync_version argument of the CHANGETABLE function in SQL Server 2008

VSTS BUG: 671297| KB Article: 2511151 
FIX: Column of a Flat File source is not imported if the next column data is one byte longer than the output column width in SSIS 2005 or in SSIS 2008

Microsoft has recommended to test all hotfixes before updating in production environment. This release required installed Service Pack 1 for SQL Server 2008 (available HERE) before starting installation process. And the restart of system (physical or virtual computer; not only SQL Server instance) could be required.

More information about this release You can find with the article: Cumulative Update 13 for SQL Server 2008 Service Pack 1

If You want to go directly to download seccion 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 2005 SP4 Cumulative Update 3 is now available

LOGO_SQLServer2005Today Microsoft released a series of updates for SQL Server. In a previous post i wrote about cumulative update for SQL Server Service Pack 3. Now it’s time for Service Pack 4.

Cumulative update package no. 3 for SQL Server 2005 SP 4 [version build: 9.00.5266] fixed seven issues in total:
* four issues for SQL Server Engine
* three issues for SQL Server Integration Services

Below You can find short information about fixed bugs:

VSTS BUG: 669144| KB Article:  2489667
FIX: SQL Server Agent job runs incorrectly if it is scheduled to run every hour on the last day of every week or month in SQL Server 2005 or in SQL Server 2008

VSTS BUG: 651082| KB Article:  2498818
FIX: Error 7359 when you run a query against a user-defined function or a view that uses a synonym on a linked server in SQL Server 2005 or SQL Server 2008

VSTS BUG: 674498| KB Article:  2510788
FIX: Success message is incorrectly logged when a distributed transaction of an SSIS 2005 package is aborted

VSTS BUG: 679617| KB Article:  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

VSTS BUG: 671319| KB Article:  2511151
FIX: Column of a Flat File source is not imported if the next column data is one byte longer than the output column width in SSIS 2005 or in SSIS 2008

As the same case in previous package (CU15 for SP3) It’s very important!! Before You trying to install this cumulative updates, You must:

  • SQL Server Install Service Pack 4 – get it HERE
  • enable SMO (SQL Server Management Object) extended stored procedures
  • enable SQL-DMO (SQL Server Distrubuted Manajement Object) extended stored procedures

More information about this release You can find with the article: Cumulative Update 3 for SQL Server 2005 Service Pack 4

If You want to go directly to download seccion go to Request Hotfix Download Site, where You can choose language (English, Spanish, Chinese, French, German, Italian, Russian, Korean, Japanese) and version (for 32-bit, 64-bit, itanium).