[EN] SQL Server 2012 SP1 Cumulative Update 8 is available

LOGO__SQLServer2012SP1Second package released last week os for SQL Server 2012 Service Pack 1. Of course this Cumulative Update no 8 {build number: 11.0.3401.0} Microsoft resolved more errors, more than for SQL Server 2008 (wrote about it in my previous post). Here is the list of fixed bugs – thirty four bugs:

VSTS BUG: 1852083 | 2297709
FIX: An error message may occur when you run a "BULK INSERT" query on a database that uses the "BULK_LOGGED" or "SIMPLE" recovery model in SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012

VSTS BUG: 1664715 | 2864930
FIX: You cannot write text that has more than 32,767 characters in Report Query Designer in SQL Server 2008 R2 BIDS or in SQL Server 2012 SSDT

VSTS BUG: 1664721 | 2875949
FIX: VSS backup operations are not successful when the auto-recovery option is enabled in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1664729 | 2878377
FIX: DecryptByKeyAutoAsymKey() function returns "NULL" value when you decrypt data that is encrypted by an asymmetric key in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1664727 | 2878807
FIX: System.NullReferenceException is thrown when an SSRS 2008 R2 or SSRS 2012 report or subscription is opened in SharePoint integrated mode

VSTS BUG: 1664733 | 2885565
FIX: Report Builder 3.0 may close unexpectedly when you search an attribute in Query Designer in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1852085 | 2888996
FIX: Data purity corruption in sys.sysbinobjs table in master database when you log on to SQL Server 2008 R2 or SQL Server 2012 by using the SA account and then run DBCC CHECKDB

VSTS BUG: 1664739 | 2890095
FIX: Interrupted distributed query may return partial result set without any error in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1664719 | 2890818
FIX: Incorrect value is returned when you run an UPDATE CUBE statement that uses the USE_WEIGHTED_INCREMENT allocation method in SSAS 2008 R2 or in SSAS 2012

VSTS BUG: 1852087 | 2891115
FIX: "The search text was not found" error when you search for numeric data that contains nonbreaking spaces in SSRS 2008 R2 or SSRS 2012

VSTS BUG: 1852089 | 2891489
FIX: Replication Log Reader Agent fails when you enable CDC and transactional replication for some columns in SQL Server 2008 R2 or SQL Server 2012

VSTS BUG: 1758070 | 2892741
FIX: Query that you run against a partitioned table returns incorrect results in SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012

VSTS BUG: 1602236 | 2896903
FIX: You cannot perform any administrator actions on the databases when a data model corruption occurs in SSAS 2012

VSTS BUG: 1629110 | 2899939
FIX: Error messages when you create a project level SMO connection manager together with a password for an SSIS 2012 project

VSTS BUG: 1769272 | 2901714
FIX: Server crashes when you import a Windows Azure SQL database to a local SQL Server 2012 database

VSTS BUG: 1640232 | 2901757
FIX: Minute is overwritten by second in XML data after you migrate from SQL Server 2005 to SQL Server 2012

VSTS BUG: 1852102 | 2904010
FIX: A small number of rows are sampled in SQL Server 2008 R2 or in SQL Server 2012 when table statistics are updated automatically or together with specified sampling rate

VSTS BUG: 1852110 | 2911026
FIX: Access violation may occur when you query sys.dm_server_memory_dumps in SQL Server 2008 R2 or SQL Server 2012

VSTS BUG: 1852106 | 2911385
FIX: Replication Queue Reader Agent crashes when you run transactional replication in SQL Server 2008 R2 or SQL Server 2012

VSTS BUG: 1683049 | 2912928
FIX: SQL Server 2012 PowerPivot for SharePoint 2010 cannot create databases when SharePoint server name is FQDN

VSTS BUG: 1852112 | 2912949
FIX: SSAS crashes when more than one thread tries to access an SSAS 2008 R2 or SSAS 2012 cube at the same time

VSTS BUG: 1636271 | 2913102
FIX: Validation of service accounts takes a long time when you set up SQL Server 2012

VSTS BUG: 1798224 | 2915611
FIX: Left arrow key does not work in Expression Editor of SSDT for Visual Studio 2012

VSTS BUG: 1811621 | 2916827
FIX: "Invalid URI: The Uri string is too long." error message when you render a SSRS 2012 report

VSTS BUG: 1812447 | 2916934
FIX: The option ‘Center map to show an embedded map element’ of tab ‘Center and Zoom’ for a map does not work in SSRS 2012

VSTS BUG: 1818080 | 2917636
FIX: SQL Server Agent cannot forward events to a different server in SQL Server 2012

VSTS BUG: 1861773 | 2918791
FIX: The system function sys.fn_hadr_backup_is_preferred_replica does not work correctly after you have CU7 for SQL Server 2012 SP1 installed

VSTS BUG: 1853069 | 2919584
FIX: Incorrect result in a PDF file when you use expressions that contains Lookup function in a SSRS 2012 report

VSTS BUG: 1814392 | 2923460
FIX: The query deadlocks when the ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT are enabled in SQL Server 2012

VSTS BUG: 1910328 | 2923838
FIX: Error messages when you use the AMR tool for SQL Server 2014 CTP2 on SQL Server 2012

VSTS BUG: 1912914 | 2923839
FIX: Oracle CDC service shows aborted status when you use CDC for Oracle by Attunity in SQL Server 2012

VSTS BUG: 1788041 | 957823
FIX: The clustered index table may take longer than you expect to be rebuilt when you use the ALTER INDEX REBUILD statement in SQL Server 2008 or SQL Server 2012

 

This update could be applied for: Microsoft SQL 2012 Service Pack 1, when used with:

  • Microsoft SQL Server 2012 Analysis Services
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Web
  • Microsoft SQL Server 2012 Standard

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 08

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 platforms: 32-bit and 64-bit) . This release is prepared as multilingual package. And here is the full list af all packages:

  • SQL Server 2012 | x86 | SQLServer2012_SP1_CU8_2917531_11_0_3401_x86

  • SQL Server 2012 | x86 | 2012_SP1_AOrcleSer_CU8_2917531_11_0_3401_x86

  • SQL Server 2012 | x86 | 2012_SP1_AOrcleDes_CU8_2917531_11_0_3401_x86

  • SQL Server 2012 | x86 | 2012_SP1_DAC_CU8_2917531_11_0_3401_x86

  • SQL Server 2012 | x86 | 2012_SP1_PPExcel_CU8_2917531_11_0_3401_x86

  • SQL Server 2012 | x64 | 2012_SP1_AOrcleSer_CU8_2917531_11_0_3401_x64

  • SQL Server 2012 | x64 | 2012_SP1_RSShrPnt_CU8_2917531_11_0_3401_x64

  • SQL Server 2012 | x64 | 2012_SP1_AOrcleDes_CU8_2917531_11_0_3401_x64

  • SQL Server 2012 | x64 | SQLServer2012_SP1_CU8_2917531_11_0_3401_x64

  • SQL Server 2012 | x64 | 2012_SP1_PPExcel_CU8_2917531_11_0_3401_x64

  • SQL Server 2012 | x64 | 2012_SP1_DAC_CU8_2917531_11_0_3401_x64

Enjoy!