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

 

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

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 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

“Column ‘‘ does not belong to table summary. (System.Data)” error message when replicating tables have the same names but are located in different schemas.
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

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

 

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

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 1374617
FIX: Shared components are installed in the wrong location when you implement a SQL Server 2008 Failover Cluster installation
SQL Server MSDN KB Number 1610447
Uninitialized object leads to crashes and potentially wrong results when executing DAX expressions with conditional calculations.
SQL Server MSDN KB Number 1610492
A simple DAX query returns unexpected results when you use PowerPivot v2 11.0.3000.0.
SQL Server MSDN KB Number 2060218
“ACTIONABLE_HEAP_CORRUPTION” when SSRS configuration file is parsed by using an invalid InstanceId.
SQL Server MSDN KB Number 2065570
NonYieldProcessTable record in RING_BUFFER_NONYIELD_PROCESSTABLE ring buffer does not have user and kernel process time.

SQL Server MSDN KB Number 2075161
Provides platform information in the log of SSRS 2012
SQL Server MSDN KB Number 1347204
FIX: 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
SQL Server MSDN KB Number 1184332
If 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 ‘‘ cannot be opened”
SQL Server MSDN KB Number 1243853
Error 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.

SQL Server MSDN KB Number 1404999
When 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.
SQL Server MSDN KB Number 1190211
Installation of SQL Server by using InstallShield ends up in a hang state. For more information, go to this Knowledge Base article.
SQL Server MSDN KB Number 1386073
After 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.

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

 

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

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 2952444
FIX: Poor performance when you use table variables in SQL Server 2012
SQL Server MSDN KB Number 2936328
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
SQL Server MSDN KB Number 2827857
FIX: DTA does not work on SQL Server 2012 instance that uses a supplementary character collation

SQL Server MSDN KB Number 2939277
FIX: Incorrect results when you run queries that contain UNION operator by using parallel query plan in SQL Server
SQL Server MSDN KB Number 950185
Improved messaging around processing errors and warnings when you work with large HTML reports.
SQL Server MSDN KB Number 950189
Improved messaging around processing errors and warnings when you work with reports with large number of parameters.

SQL Server MSDN KB Number 994470
Incorrect results when you work with block mode unary operators.
SQL Server MSDN KB Number 1041277
DPM’s full backup on the server with AlwaysOn secondary will be converted to copy_only backup.
SQL Server MSDN KB Number 1278767
The value of tabular instance perfmon counters: Memory\VertiPaq KB is always 0.
SQL Server MSDN KB Number 1355346
The end SCOPE statement does not match the opening SCOPE statement.

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

 

List of Bugs Fixed in SQL Server 2012 SP2 – 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 2 for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 2963412
New DMF sys.dm_fts_index_keywords_position_by_document in SQL Server 2012 SP2
SQL Server MSDN KB Number 2966520
FIX: New log files are not created when you restart the Reporting Services Windows Service in SSRS 2012 on January 1
SQL Server MSDN KB Number 2966519
FIX: No error message when log backup failed in SQL Server 2012

SQL Server MSDN KB Number 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
SQL Server MSDN KB Number 2966522
FIX: File Share subscription doesn’t populate the description column in SSRS 2012
SQL Server MSDN KB Number 2966523
FIX: The “Name” drop-down list is empty when an SSRS 2012 report is specified

SQL Server MSDN KB Number 2964762
FIX: Event ID 22 or error 0xC1000016 will be logged when you use Discover command in SSAS 2012
SQL Server MSDN KB Number 2972285
FIX: Performance issues when you use SSISDB as your deployment store in SQL Server 2012
SQL Server MSDN KB Number 2965035
SSAS 2012 logging feature improvement in SQL Server 2012 Service Pack 2

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

 

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

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 2028830
FIX: Shared components are installed in the wrong location when you implement a SQL Server 2008 or SQL Server 2012 Failover Cluster installation
SQL Server MSDN KB Number 2963382
FIX: Can’t connect to the server when you run a cube creation MDX query in SSAS 2012
SQL Server MSDN KB Number 2927741
FIX: Image is not displayed correctly in the webpage when you use DrillThrough action on an SSRS 2012 report

SQL Server MSDN KB Number 2963383
FIX: Text truncated when you use HPB renderer to view a report in SSRS 2012
SQL Server MSDN KB Number 2963384
FIX: SQL Server crashes when the log file of tempdb database is full in SQL Server 2012
SQL Server MSDN KB Number 2963386
FIX: SSRS 2012 fails with IsolatedStorageException when subscriptions exported to Excel worksheets are larger than 10 MB

SQL Server MSDN KB Number 2963388
FIX: SSRS 2012 cannot export a report that is larger than 10 MB to Excel format
SQL Server MSDN KB Number 2963404
FIX: Rollback causes database to go to suspect mode in SQL Server 2012
SQL Server MSDN KB Number 2806979
FIX: Poor performance when you run a query against a table in an RCSI-enabled database in SQL Server 2012

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

 

List of Bugs Fixed in SQL Server 2012 SP2 CU7 – Part 4

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 Cumulative Update 7 (SP 2 CU 7) for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 3063438
FIX: XSLT transformation fails when you run an SSIS 2014 package that contains multiple concurrent XML tasks Integration Services
SQL Server MSDN KB Number 2965654
FIX: SSRS 2012 or SSRS 2014 report is cut horizontally after you apply Update MS13-088 on a computer Reporting Services
SQL Server MSDN KB Number 3070147
Incorrect values are included in the description column when you query the sys.dm_xe_objects dynamic management object in SQL Server SQL service

SQL Server MSDN KB Number 3066299
FIX: Non-English items display in the MDS Explorer when you set language settings for web browser to English Master Data Services (MDS)
SQL Server MSDN KB Number 3069320
FIX: A workflow never starts in a SharePoint 2013 environment when you use SQL Server 2012 Master Data Services to start the workflow MDS

SQL Server MSDN KB Number 972759
FIX: Installing SQL Server 2008 Service Pack 1 may reset the “max_worker_threads” column value for a SQL Server Agent subsystem Management Tools
SQL Server MSDN KB Number 2820068
Can’t install SQL Server by using InstallShield or bootstrapping application Setup & Install

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

 

List of Bugs Fixed in SQL Server 2012 SP2 CU7 – Part 3

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 Cumulative Update 7 (SP 2 CU 7) for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 3074922
FIX: Incorrect result when you execute a full-text query with parallel execution plan in SQL Server 2012 SQL performance
SQL Server MSDN KB Number 3074425
FIX: Contention occurs when you execute many ad-hoc queries in SQL Server 2012 SQL service
SQL Server MSDN KB Number 3075176
FIX: You receive incorrect results from the CHANGETABLE() function when snapshot isolation for a SQL Server 2012 database SQL service

SQL Server MSDN KB Number 3076444
FIX: Cannot enable “change data capture” on a table that uses a unique index with more than one included column in SQL Server 2012 SP2 SQL service
SQL Server MSDN KB Number 3075669
FIX: SSAS 2012 crashes when you execute an MDX query that contains a large number of Union expressions Analysis Services
SQL Server MSDN KB Number 3051243
FIX: Error 2601 occurs when you add new articles with join filters to existing merge publications SQL service

SQL Server MSDN KB Number 3064292
FIX: SHARING VIOLATION error 6518 occurs on CLR assembly microsoft.sqlserver.types.dll in SQL Server 2012 SQL service
SQL Server MSDN KB Number 3073907
FIX: A SQL Server 2012 SSIS package with an Execute SQL Task may stop responding 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

 

List of Bugs Fixed in SQL Server 2012 SP2 CU7 – 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 2 Cumulative Update 7 (SP 2 CU 7) for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 3068439
FIX: Indexed view returns incorrect result after insert or delete operation on the base table in SQL Server 2012 SQL performance
SQL Server MSDN KB Number 3068468
FIX: Schema lock occurs on a table with large data when you delete lots of rows from it in SQL Server 2012 SQL service
SQL Server MSDN KB Number 3068703
FIX: Error messages are logged when you execute a non-cacheable auto-parameterized query in SQL Server 2012 SQL service

SQL Server MSDN KB Number 3068776
FIX: Incorrect results occur in a rare scenario when you run a query that contains a nested loop join and performance spool in its inner side in SQL Server 2012 SQL performance
SQL Server MSDN KB Number 3069154
FIX: You cannot set a SQL Server 2012 database to single-user mode if the database is read-only SQL service
SQL Server MSDN KB Number 3069155
FIX: A deadlock occurs when you execute the sp_estimate_data_compression_savings stored procedure in SQL Server 2012 SQL service

SQL Server MSDN KB Number 3073530
FIX: Access Violation error occurs when you run DDL SQL statements on a database in an instance of SQL Server 2012 Analysis Services
SQL Server MSDN KB Number 3074434
FIX: Out of memory error when the virtual address space of the SQL Server process is very low on available memory SQL service
SQL Server MSDN KB Number 3074535
FIX: The Resource database is missing after you install updates or service packs for instances of SQL Server 2012 one after another and then restart the server SQL service

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

 

List of Bugs Fixed in SQL Server 2012 SP2 CU7 – Part 1

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 Cumulative Update 7 (SP 2 CU 7) for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 3983191
FIX: The changes in Oracle databases are not replicated to SQL Server 2012 or SQL Server 2014 databases correctly Integration Services
SQL Server MSDN KB Number 3030352
FIX: The change table is ordered incorrectly for updated rows after you enable change data capture for a Microsoft SQL Server 2012 database SQL service
SQL Server MSDN KB Number 3052461
FIX: Some attributes in element are ignored when you transform XML file in SSIS 2012 Integration Services

SQL Server MSDN KB Number 3062001
FIX: “Failed to create kernel event for collection set” error occurs when you use Data Collection in SQL Server 2012 Management Tools
SQL Server MSDN KB Number 3061215
FIX: “Cannot read 8 bytes from file” error occurs when you use SSIS 2012 Integration Services
SQL Server MSDN KB Number 3064454
FIX: Hash or merge join hints may be ignored when you execute a query in SQL Server 2012 SQL performance

SQL Server MSDN KB Number 3065060
FIX: “Unable to create restore plan due to break in the LSN chain” error when you restore differential backup in SSMS Management Tools
SQL Server MSDN KB Number 3068351
FIX: ROLAP Distinct Count on data source is not started when it is running from SSAS 2012 to back-end SQL Server 2014 Analysis Services
SQL Server MSDN KB Number 3068359
FIX: “Cannot find the OLAP cube Model” error when you update the pivot table in a SharePoint document in SQL Server 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

 
1 2 3 7