List of Bugs Fixed in SQL Server 2012 SP2 – PART 6

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 2 for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 785064
“Value of ‘null’ is not valid for ‘stream’ ” error message when you work with customer pipeline components in Business Intelligence Development Studio (BIDS).
SQL Server MSDN KB Number 785151
When 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.
SQL Server MSDN KB Number 791929

“A system assertion check has failed” error message when you insert data into a partitioned view that has triggers.
SQL Server MSDN KB Number 797967
Create script duplicates the statements when scripting column level permissions in SSMS.
SQL Server MSDN KB Number 799430
SSMS may crash when you try to refresh the SSMS window icon on the task bar.
SQL Server MSDN KB Number 804901

Deploying 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.
SQL Server MSDN KB Number 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.

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 *