Cumulative update package 8 for SQL Server 2012 Service Pack 1

Applies to: SQL Server 2012 Analysis ServicesSQL Server 2012 DeveloperSQL Server 2012 Enterprise

This article describes cumulative update package 8 (Build number: 11.0.3401.0) for Microsoft SQL Server 2012 Service Pack 1 (SP1). This update contains hotfixes for issues that were fixed after the release of SQL Server 2012 SP1.

How to obtain this cumulative update package

Click "Hotfix Download Available" at the top of this Knowledge Base article. If the "Hotfix Request" page doesn't appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.

Hotfixes that are included in this cumulative update package

VSTS bug numberKB article numberDescription
18520832297709 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
16647152864930 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
16647212875949 FIX: VSS backup operations are not successful when the auto-recovery option is enabled in SQL Server 2008 R2 or in SQL Server 2012
16647292878377 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
16647272878807 FIX: System.NullReferenceException is thrown when an SSRS 2008 R2 or SSRS 2012 report or subscription is opened in SharePoint integrated mode
16647332885565 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
18520852888996 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
16647392890095 FIX: Interrupted distributed query may return partial result set without any error in SQL Server 2008 R2 or in SQL Server 2012
16647192890818 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
18520872891115 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
18520892891489 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
17580702892741 FIX: Query that you run against a partitioned table returns incorrect results in SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012
16022362896903 FIX: You cannot perform any administrator actions on the databases when a data model corruption occurs in SSAS 2012
16291102899939 FIX: Error messages when you create a project level SMO connection manager together with a password for an SSIS 2012 project
17692722901714 FIX: Server crashes when you import a Microsoft Azure SQL database to a local SQL Server 2012 database
16402322901757 FIX: Minute is overwritten by second in XML data after you migrate from SQL Server 2005 to SQL Server 2012
18521022904010 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
18521102911026 FIX: Access violation may occur when you query sys.dm_server_memory_dumps in SQL Server 2008 R2 or SQL Server 2012
18521062911385 FIX: Replication Queue Reader Agent crashes when you run transactional replication in SQL Server 2008 R2 or SQL Server 2012
16830492912928 FIX: SQL Server 2012 PowerPivot for SharePoint 2010 cannot create databases when SharePoint server name is FQDN
18521122912949 FIX: SSAS crashes when more than one thread tries to access an SSAS 2008 R2 or SSAS 2012 cube at the same time
16362712913102 FIX: Validation of service accounts takes a long time when you set up SQL Server 2012
17982242915611 FIX: Left arrow key does not work in Expression Editor of SSDT for Visual Studio 2012
18116212916827 FIX: "Invalid URI: The Uri string is too long." error message when you render a SSRS 2012 report
18124472916934 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
18180802917636 FIX: SQL Server Agent cannot forward events to a different server in SQL Server 2012
18617732918791 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
18530692919584 FIX: Incorrect result in a PDF file when you use expressions that contains Lookup function in a SSRS 2012 report
18143922923460 FIX: The query deadlocks when the ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT are enabled in SQL Server 2012
19103282923838 FIX: Error messages when you use the AMR tool for SQL Server 2014 CTP2 on SQL Server 2012
19129142923839 FIX: Oracle CDC service shows aborted status when you use CDC for Oracle by Attunity in SQL Server 2012
1788041957823 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

Notes for this update

Installation and deployment

  • We recommend that you test hotfixes before you deploy them in a production environment.
  • This cumulative package is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems. The updates in this 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 2012 service pack that contains the hotfixes in this package.

Cumulative update

Because the builds are cumulative, each new update release contains all the hotfixes and all the security updates that were included with the previous SQL Server 2012 update release. We recommend that you consider applying
the most recent update release .

Cumulative update package information


To apply this cumulative update package, you must be running SQL Server 2012 SP1.

Restart information

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

Registry information

To use one of the hotfixes in this package, you do not have to make any changes to the registry.