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 2 for Microsoft SQL Server 2012.
SQL Server MSDN KB Number 714689
Evaluation 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.
SQL Server MSDN KB Number 735543
Database goes into a restore mode when its backup is restored as a different database on the same instance.
SQL Server MSDN KB Number 736509
You 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.
SQL Server MSDN KB Number 740181
SSMS does not fully manage Full-Text in SQL Server Express.
SQL Server MSDN KB Number 745566
SQL Server SMO ignores default constraint in SQL Server 2012 and SQL Server 2014.
SQL Server MSDN KB Number 764197
SSMS handles Numbered Stored procedures inconsistently.
SQL Server MSDN KB Number 769121
SQL Server MSDN KB Number 773710
After 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.
SQL Server MSDN KB Number 774317
SSMS occasionally crashes on close, which then causes it to automatically restart
Hope this was helpful.
This is applicable for below versions of SQL Server
SQL Server 2014
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings