Bugs that are fixed in SQL Server 2012 Service Pack 2

Applies to: SQL Server 2012 Analysis ServicesSQL Server 2012 EnterpriseSQL Server 2012 Developer


This article lists the bugs that are fixed in Microsoft SQL Server 2012 Service Pack 2 (SP2).

  • Additional fixes that are not documented here may also be included in the service pack.
  • This list will be updated when more articles are released.
For more information about how to obtain SQL Server 2012 service packs, click the following article number to view the article in the Microsoft Knowledge Base:
2755533 How to obtain the latest service pack for SQL Server 2012
Note For more information about which download you should select from the available downloads list, check the release notes here.

More Information

SQL Server 2012 service packs are cumulative updates and upgrade all editions and service levels of SQL Server 2012 to SP2. In addition to the fixes that are listed in this article, this service pack contains up to and including Microsoft SQL Server 2012 SP1 Cumulative Update 9 (CU9) .

For more information about the cumulative update packages that are available for SQL Server 2012 SP1, click the following article number to view the article in the Microsoft Knowledge Base:
2772858 The SQL Server 2012 builds that were released after SQL Server 2012 Service Pack 1 was released

Issues that are fixed in this service pack

For more information about the bugs that are fixed in SQL Server 2012 SP2, click the following article numbers to view the articles in the Microsoft Knowledge Base.
VSTS bug numberKB article numberDescription
13746172028830 FIX: Shared components are installed in the wrong location when you implement a SQL Server 2008 or SQL Server 2012 Failover Cluster installation
1703014 2963382 FIX: Can't connect to the server when you run a cube creation MDX query in SSAS 2012
2011247 2927741 FIX: Image is not displayed correctly in the webpage when you use DrillThrough action on an SSRS 2012 report
2034994 2963383 FIX: Text truncated when you use HPB renderer to view a report in SSRS 2012
1769469 2963384 FIX: SQL Server crashes when the log file of tempdb database is full in SQL Server 2012
1973168 2963386 FIX: SSRS 2012 fails with IsolatedStorageException when subscriptions exported to Excel worksheets are larger than 10 MB
1973196 2963388 FIX: SSRS 2012 cannot export a report that is larger than 10 MB to Excel format
787358 2963404 FIX: Rollback causes database to go to suspect mode in SQL Server 2012
1043717 2806979 FIX: Poor performance when you run a query against a table in an RCSI-enabled database in SQL Server 2012
1178585 2963412 New DMF sys.dm_fts_index_keywords_position_by_document in SQL Server 2012 SP2
1182241 2966520 FIX: New log files are not created when you restart the Reporting Services Windows Service in SSRS 2012 on January 1
1240848 2966519 FIX: No error message when log backup failed in SQL Server 2012
1253861 2936004 FIX: Visual Studio 2012 crashes because of access violation when the data source binding is completed in Report Viewer 2012 UI in local mode
1262029 2966522 FIX: File Share subscription doesn't populate the description column in SSRS 2012
1481773 2966523 FIX: The "Name" drop-down list is empty when an SSRS 2012 report is specified
14193672964762 FIX: Event ID 22 or error 0xC1000016 will be logged when you use Discover command in SSAS 2012
21039032972285 FIX: Performance issues when you use SSISDB as your deployment store in SQL Server 2012
20215812965035 SSAS 2012 logging feature improvement in SQL Server 2012 Service Pack 2
2037492952444 FIX: Poor performance when you use table variables in SQL Server 2012
20950642936328 FIX: Access violation occurs when you run CHECKTABLE or CHECKDB against a table that has persisted computed columns in SQL Server 2008 R2 or SQL Server 2012
12224722827857 FIX: DTA does not work on SQL Server 2012 instance that uses a supplementary character collation
21242092939277 FIX: Incorrect results when you run queries that contain UNION operator by using parallel query plan in SQL Server
Resolutions to the following issues are also included in SQL Server 2012 SP2.
VSTS bug numberDescription
950185Improved messaging around processing errors and warnings when you work with large HTML reports.
950189Improved messaging around processing errors and warnings when you work with reports with large number of parameters.
994470Incorrect results when you work with block mode unary operators.
1041277DPM’s full backup on the server with AlwaysOn secondary will be converted to copy_only backup.
1278767The value of tabular instance perfmon counters: Memory\VertiPaq <TypeName> KB is always 0.
1355346The end SCOPE statement does not match the opening SCOPE statement.
1374617FIX: Shared components are installed in the wrong location when you implement a SQL Server 2008 Failover Cluster installation
1610447Uninitialized object leads to crashes and potentially wrong results when executing DAX expressions with conditional calculations.
1610492A simple DAX query returns unexpected results when you use PowerPivot v2 11.0.3000.0.
2060218"ACTIONABLE_HEAP_CORRUPTION" when SSRS configuration file is parsed by using an invalid InstanceId.
2065570NonYieldProcessTable record in RING_BUFFER_NONYIELD_PROCESSTABLE ring buffer does not have user and kernel process time.
2075161Provides platform information in the log of SSRS 2012
1347204FIX: Access Violation when you insert data into a table that has a column with a sequence default from a cross-database transaction in SQL Server 2012
1184332If a tail log backup is performed against the model database, model database will freeze in restoring state during a server restart that will prevent the SQL Server from starting successfully. This is because Tempdb database could not be created during the server startup and you receive the following error message: “Database '<DatabaseName>' cannot be opened"
1243853Error 3456 occurs when restoring the log backup of a bulk-logged DB where a new data file was added with an initial size greater than 64704KB.
1404999When you drop of a database snapshot is issued in a session with a LOCK_TIMEOUT setting, a time-out error may occur followed by an assertion error.
1190211Installation of SQL Server by using InstallShield ends up in a hang state. For more information, go to this Knowledge Base article.
1386073After you install SQL Server 2012 SP2, when SQL Server is stopped from either configuration manager or service control manager, an informational message is logged to the SQL Server immediately after shutdown is issued. In earlier versions, we issued this messages after internal services, such as the .NET Framework, service broker, were stopped.
Fixes for Connect Items submitted by the community
Connect Bug IDDescription
714689Evaluation results are written to output xml file multiple times when you implement Enterprise Management Framework against multiple servers and an error occurs against one of the servers in the list.
735543Database goes into a restore mode when its backup is restored as a different database on the same instance.
736509You cannot debug a stored procedure that calls sp_executesql in SQL Server Management Studio (SSMS). When F11 is pressed, you receive an 'Object reference not set to an instance of object' error message.
740181SSMS does not fully manage Full-Text in SQL Server Express.
745566SQL Server SMO ignores default constraint in SQL Server 2012 and SQL Server 2014.
764197SSMS handles Numbered Stored procedures inconsistently.
769121"Column '<column name>' does not belong to table summary. (System.Data)" error message when replicating tables have the same names but are located in different schemas.
773710After reverting to a database snapshot that contains full-text indexes, you cannot create any ft_catalogs until you either restart SQL Server, detach and then attach the database, or take the database offline and then set the database online.
774317SSMS occasionally crashes on close, which then causes it to automatically restart
785064"Value of 'null' is not valid for 'stream' " error message when you work with customer pipeline components in Business Intelligence Development Studio (BIDS).
785151When you execute queries with Show Actual Query Plan turned on, the result of Null is returned, and you receive the following error message:
Error: Msg 50000, Level 16, State 10, Procedure test, Line 34 String or binary data would be truncated.
791929"A system assertion check has failed" error message when you insert data into a partitioned view that has triggers.
797967Create script duplicates the statements when scripting column level permissions in SSMS.
799430SSMS may crash when you try to refresh the SSMS window icon on the task bar.
804901Deploying new versions of large projects encounters a time-out during deployment into SSIS Catalog database (SSISDB). Additionally, you receive the following error messages:
Failed to deploy project. For more information, query the operation_messages view for the operation identifier ’219′. (Microsoft SQL Server, Error: 27203) Failed to deploy the project. Fix the problems and try again later.:Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated.
805659"Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries" error message when you parse or execute stored procedure.

Highlights for SQL Server 2012 SP2


For more information about how to determine the current SQL Server version and edition, click the following article number to view the article in the Microsoft Knowledge Base:
321185 How to determine the version and edition of SQL Server and its components