List of Bugs Fixed in SQL Server 2014 SP1 CU2 – Part 2

SQLServerF1

With every release of SQL Server product or subsequent service packs or Cumulative updates, new bugs are encountered or discovered. Below are some of the bugs which were fixed with the release of Service Pack 1 Cumulative Update 2 (SP 1 CU2) for Microsoft SQL Server 2014.

SQL Server MSDN KB Number 5181914
FIX: You cannot set a SQL Server 2012 or 2014 database to single-user mode if the database is read-only SQL service
SQL Server MSDN KB Number 5181908
FIX: Cannot enable “change data capture” on a table that uses a unique index with more than one included column in SQL Server 2012 or 2014 SQL service
SQL Server MSDN KB Number 4772921
FIX: Cannot use SQL Server 2014 SQL Profiler to connect to an instance of SQL Server 2005 Management Tools

SQL Server MSDN KB Number 5181952
FIX: Error messages are logged when you execute a non-cacheable auto-parameterized query in SQL Server 2012 or 2014 SQL service
SQL Server MSDN KB Number 5196810
FIX: “Requested value was not found” error when you deploy a SQL Server 2014 database to Windows Azure Management Tools
SQL Server MSDN KB Number 5036505
FIX: Can’t view the properties of a contained database in Object Explorer in SQL Server 2014 SP1 Management Tools

SQL Server MSDN KB Number 4921466
FIX: Error 1635 occurs when you use Product Update to install SQL Server 2014 SP1 and SQL Server 2014 SP1 CU1 Setup & Install
SQL Server MSDN KB Number 4776005
Restore Log with Standby Mode on an Advanced Format disk may cause a 9004 error in SQL Server 2008 R2 or SQL Server 2012 SQL service
SQL Server MSDN KB Number 4745317
FIX: Result of aggregated values is incorrect when you execute an MDX query in SSAS 2012 or SSAS 2014 Analysis Services
SQL Server MSDN KB Number 4745296
FIX: Poor performance when you run an MDX query that contains a sub-select of different granularities in SSAS 2012 Analysis Services

Hope this was helpful.

This is applicable for below versions of SQL Server

SQL Server 2014

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings

 

Leave a Reply

Your email address will not be published. Required fields are marked *