[EN] SQL Server 2012 SP2 Cumulative Update #7 is available!

Just one update package in July. In this Cumulative Update No 7 {build 11.0.5623.0} for Microsoft SQL Server 2012 Service Pack 2 (SP2) released two weeks ago Microsoft fixed thirty four bugs. Important information for all DBA (and their SEC friends) is that SQL Server 2012 SP2 Cumulative Update 7 contains the recently released Security Bulletin MS15-058 (KB3065718).

VSTSBUG: 3983191 | 3029096
FIX: The changes in Oracle databases are not replicated to SQL Server 2012 or SQL Server 2014 databases correctly
Integration Services

VSTSBUG: 4346613 | 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

VSTSBUG: 4178633 | 3052461
FIX: Some attributes in element are ignored when you transform XML file in SSIS 2012
Integration Services

VSTSBUG: 4639762 | 3062001
FIX: “Failed to create kernel event for collection set” error occurs when you use Data Collection in SQL Server 2012
Management Tools

VSTSBUG: 4602046 | 3061215
FIX: “Cannot read 8 bytes from file” error occurs when you use SSIS 2012
Integration Services

VSTSBUG: 4713547 | 3064454
FIX: Hash or merge join hints may be ignored when you execute a query in SQL Server 2012
SQL performance

VSTSBUG: 4715206 | 3065060
FIX: “Unable to create restore plan due to break in the LSN chain” error when you restore differential backup in SSMS
Management Tools

VSTSBUG: 4743330 | 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

VSTSBUG: 4662556 | 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

VSTSBUG: 4520905 | 3068439
FIX: Indexed view returns incorrect result after insert or delete operation on the base table in SQL Server 2012
SQL performance

VSTSBUG: 4694348 | 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

VSTSBUG: 4804569 | 3068703
FIX: Error messages are logged when you execute a non-cacheable auto-parameterized query in SQL Server 2012
SQL service

VSTSBUG: 4805976 | 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

VSTSBUG: 4524535 | 3069154
FIX: You cannot set a SQL Server 2012 database to single-user mode if the database is read-only
SQL service

VSTSBUG: 4436770 | 3069155
FIX: A deadlock occurs when you execute the sp_estimate_data_compression_savings stored procedure in SQL Server 2012
SQL service

VSTSBUG: 4925413 | 3073530
FIX: Access Violation error occurs when you run DDL SQL statements on a database in an instance of SQL Server 2012
Analysis Services

VSTSBUG: 4500307 | 3074434
FIX: Out of memory error when the virtual address space of the SQL Server process is very low on available memory
SQL service

VSTSBUG: 4928677 | 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

VSTSBUG: 4683321 | 3074922
FIX: Incorrect result when you execute a full-text query with parallel execution plan in SQL Server 2012
SQL performance

VSTSBUG: 4547054 | 3074425
FIX: Contention occurs when you execute many ad-hoc queries in SQL Server 2012
SQL service

VSTSBUG: 5013383 | 3075176
FIX: You receive incorrect results from the CHANGETABLE() function when snapshot isolation for a SQL Server 2012 database
SQL service

VSTSBUG: 4495133 | 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

VSTSBUG: 4781857 | 3075669
FIX: SSAS 2012 crashes when you execute an MDX query that contains a large number of Union expressions
Analysis Services

VSTSBUG: 4376957 | 3051243
FIX: Error 2601 occurs when you add new articles with join filters to existing merge publications
SQL service

VSTSBUG: 4705249 | 3064292
FIX: SHARING VIOLATION error 6518 occurs on CLR assembly microsoft.sqlserver.types.dll in SQL Server 2012
SQL service

VSTSBUG: 4933896 | 3073907
FIX: A SQL Server 2012 SSIS package with an Execute SQL Task may stop responding
Analysis Services

VSTSBUG: 4691746 | 3063438
FIX: XSLT transformation fails when you run an SSIS 2014 package that contains multiple concurrent XML tasks
Integration Services

VSTSBUG: 4716342 | 2965654
FIX: SSRS 2012 or SSRS 2014 report is cut horizontally after you apply Update MS13-088 on a computer
Reporting Services

VSTSBUG: 4939175 | 3070147
FIX: Incorrect values are included in the description column when you query the sys.dm_xe_objects dynamic management object in SQL Server
SQL service

VSTSBUG: 4759209 | 3066299
FIX: Non-English items display in the MDS Explorer when you set language settings for web browser to English
Master Data Services (MDS)

VSTSBUG: 4817323 | 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

VSTSBUG: 4465179 | 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

VSTSBUG: 4834221 | 2820068
FIX: Can’t install SQL Server by using InstallShield or bootstrapping application
Setup & Install

 

This update could be applied Microsoft SQL Server 2014, when used applies to

  • Microsoft SQL Server 2012 Service Pack 2 ONLY

 

Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 7

You may have to restart the computer after you apply this cumulative update. If you use any hybrid technology, such a Replication, AlwaysOn, Clustering:  If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP: step1: Install the service pack on the passive node / step2: Install the service pack on the active node (This step requests servicerestart).

If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for both platforms: 64-bit and 32-bit) . This release is prepared as multilingual package. And here is the full list af all packages:

    SQLServer2012_SP2_CU7_3072100_11_0_5623_x64
    2012_SP2_AOrcleDes_CU7_3072100_11_0_5623_x64
    2012_SP2_AOrcleSer_CU7_3072100_11_0_5623_x64
    2012_SP2_AOrcleDes_CU7_3072100_11_0_5623_x86
    SQLServer2012_SP2_CU7_3072100_11_0_5623_x86
    2012_SP2_AOrcleSer_CU7_3072100_11_0_5623_x86

     

Enjoy!

[EN] SQL Server 2012 SP2 Cumulative Update #5 is available!

LOGO__SQLServer2012SP2First package for updates which have been released in March is for SQL Server 2012 with Service Pack 2. In this Cumulative Updates No 5 {build no 11.0.5582.0} Microsoft resolved almost thirty bugs. Some fixed errors has been published in Cumulative Update No 6 for SQL Server 2014 {post here} like SOS_CACHESTORE or PowerPivot bugs. Here is the full list of fixed bugs.

 

VSTS BUG:  4034265 | KB: 2989043
FIX: Access denied when you view report history on a SharePoint site with the View Items permission
Reporting Services

VSTS BUG:  4067264 | KB: 3016165
FIX: Arithmetic overflow error occurs when you add manually initialized subscriptions for publication in SQL Server
SQL service

VSTS BUG:  3746215 | KB: 3020350
FIX: ISServerExec crashes when you execute an SSIS package that contains another set of child SSIS packages in SSIS 2012
Integration Services

VSTS BUG:  4067256 | KB: 3023629
FIX: High CPU usage after you use DTExec utility to process SSAS 2012 data mining models
Analysis Services

VSTS BUG:  4067259 | KB: 3026082
FIX: SOS_CACHESTORE spinlock contention on system table rowset cache causes high CPU usage in SQL Server 2012 or 2014
SQL service

VSTS BUG:  4067262 | KB: 3026083
FIX: SOS_CACHESTORE spinlock contention on ad hoc SQL Server plan cache causes high CPU usage in SQL Server 2012 or 2014
SQL service

VSTS BUG:  4067274 | KB: 3028322
FIX: It takes longer time than usual to render a report in SSRS 2012 or SSRS 2014
Reporting Services

VSTS BUG:  3995494 | KB: 3029776
FIX: Memory consumption increases quickly and surpasses HardMemoryLimit when you run a query in Many-To-Many dimension
Analysis Services

VSTS BUG:  3980976 | KB: 3032476
FIX: Memory leak in USERSTORE_SCHEMAMGR and CPU spikes occur when you use temp table in SQL Server 2012
SQL service

VSTS BUG:  4058285 | KB: 3033041
FIX: Error occurs and the execution hangs when you run an SSIS package that connects to Flat File Source
Integration Services

VSTS BUG:  4077857 | KB: 3034492
FIX: “Call to Excel Services returned an error” error when you refresh the document in the PowerPivot Gallery
Analysis Services

VSTS BUG:  4124969 | KB: 3034679
FIX: AlwaysOn availability groups are reported as NOT SYNCHRONIZING
High Availability

VSTS BUG:  3987784 | KB: 3036201
FIX: The notification email link is broken when a special character is part of the URL in SQL Server 2012 MDS
Master Data Services (MDS)

VSTS BUG:  4019503 | KB: 3037624
FIX: Complex parallel query does not respond in SQL Server 2012
SQL performance

VSTS BUG:  4138602 | KB: 3038267
FIX: Error “[BC30494] line is too long” occurs when you upload an SSRS 2012 report to Reporting Service Report Manager
Reporting Services

VSTS BUG:  4001004 | KB: 3038331
FIX: Query that contains subscription parameters is fired multiple times when you create a new subscription in SSRS 2012
Reporting Services

VSTS BUG:  4111094 | KB: 3038332
FIX: Data Alerts tables are filled up and never be cleared old data when you use alerts for SSRS 2012 reports
Reporting Services

VSTS BUG:  4136827 | KB: 3038943
FIX: Error 4360 when you restore the backup of secondary replica to another server in AlwaysOn Availability Groups
High Availability

VSTS BUG:  4142251 | KB: 3039035
FIX: “Parameter type cannot be deduced” when you execute sp_describe_undeclared_parameters in SQL Server 2012
SQL service

VSTS BUG:  4166567 | KB: 3040675
FIX: Data-driven subscription with email notification shows “0 errors” when email delivery fails in SSRS 2012
Reporting Services

VSTS BUG:  4166534 | KB: 3040804
FIX: “Access Denied” error occurs when you run an XML validation task in SSIS 2012
Integration Services

VSTS BUG:  4166659 | KB: 3041056
FIX: A tablix data region is rendered as corrupted in SSRS in Cumulative Update 3 for SQL Server 2012 SP2
Reporting Services

VSTS BUG:  4168490 | KB: 3041859
FIX: Performance issue occurs when you use sqlncli11.dll ODBC driver to access SQL Server in an application
SQL connectivity

VSTS BUG:  4203721 | KB: 3042007
FIX: Access violation may occur when you run a query against the sys.dm_exec_procedure_stats DMV joined on plan_handle
SQL service

VSTS BUG:  4142191 | KB: 3042077
FIX: MDX query returns incorrect results when you run it with subselect after an UPDATE CUBE statement in SSAS 2012
Analysis Services

VSTS BUG:  4073547 | KB: 3042135
FIX: Access violation and “No exceptions should be raised by this code” error occur when you use SQL Server 2012
SQL service

VSTS BUG:  4049132 | KB: 3044958
FIX: SQL Server 2012 shuts down unexpectedly when you run DBCC CHECKDB and the rollback recovery on the snapshot fails
SQL service

 

This update could be applied Microsoft SQL Server 2012 Service Pack 2, when used with:

     – Microsoft SQL Server 2012 Enterprise

     – Microsoft SQL Server 2012 Developer

     – Microsoft SQL Server 2012 Express

     – Microsoft SQL Server 2012 Standard

     – Microsoft SQL Server 2012 Web

     – Microsoft SQL Server 2012 Analysis Services

     – Microsoft SQL Server 2012 Business Intelligence

     – Microsoft SQL Server 2012 for Embedded Systems

     – Microsoft SQL Server 2012 Parallel Data Warehouse

     – SQL Server 2012 Reporting Services

 

Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 5

You may have to restart the computer after you apply this cumulative update. If you use any hybrid technology, such a Replication, AlwaysOn, Clustering:  If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP: step1: Install the service pack on the passive node / step2: Install the service pack on the active node (This step requests servicerestart).

If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for both platforms: 64-bit and 32-bit) . This release is prepared as multilingual package. And here is the full list af all packages:

    SQLServer2012_SP2_CU5_3037255_11_0_5582_x86

    SQLServer2012_SP2_CU5_3037255_11_0_5582_x64

Enjoy!

[EN] SQL Server 2012 SP2 Cumulative Update #4 is available!

LOGO__SQLServer2012SP2New Years, new updates. First update for SQL Server Environment has been published week ago. In this Cumulative Update No 4 {build no 11.0.5569.0} for SQL Server 2012 SP2 Microsoft fixed over forty bugs, and full list is below. Interesting fixed errora are especially for SharePoint 2013 area, DBCC CHECKDB and no-english installation.

VSTS BUG: 3720622 | KB: 2793580
FIX: An update enables you to exclude system databases from Query Statistics collection sets when you use the management data warehouse in SQL Server
Management Tools

VSTS BUG: 3720640 | KB: 2840657
FIX: Performance decreases when you stage many records in MDS for SQL Server 2012
Master Data Services (MDS)

VSTS BUG: 3655067 | KB: 2970136
FIX: Cannot remove backup file after you restore the database from Windows Azure in SQL Server 2014 or SQL Server 2012
SQL service

VSTS BUG: 3720631 | KB: 2994082
FIX: Error when you edit models for some groups or users in SQL Server 2012 MDS
MDS

VSTS BUG: 3720636 | KB: 2995352
FIX: “No catalog entry found for partition ID <ID> in database <Database Name>” error when you use SQL Server 2012
SQL service

VSTS BUG: 3743972 | KB: 2995622
FIX: “Specified cast is not valid” when you load an XML document that has time zone information in SSIS 2012 or SSIS 2014
Integration Services

VSTS BUG: 3720644 | KB: 2997020
FIX: “An item with the same key has already been added” error when you review a report in SSRS 2012
Reporting Services

VSTS BUG: 3720634 | KB: 2998870
FIX: “The record ID is incorrect” error when you use DAX to execute query in a dimension in SSAS 2012 or SSAS 2014
Analysis Services

VSTS BUG: 3720650 | KB: 3000494
FIX: The slides of a PowerPoint file that is exported from a PowerView report show blank when you open it in slider show mode
Reporting Services

VSTS BUG: 3720646 | KB: 3005300
FIX: High CPU consumption when you use spatial data type and associated methods in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 3360706 | KB: 3006838
FIX: Instance of SSAS 2012 crashes when cube writeback commit and processing transactions are executed at the same time
Analysis Services

VSTS BUG: 3720648 | KB: 3008000
FIX: Error when you use Office 15.0 Access Database Engine OLE DB Provider as data source in SSMS 2012 or SSMS 2014
Integration Services

VSTS BUG: 3456411 | KB: 3010148
FIX: Non-admin role cannot receive correct ChildCount estimates for parent/child dimension leaf members in SSAS 2012
Analysis Services

VSTS BUG: 3508146 | KB: 3011465
FIX: Sequence object generates duplicate sequence values when SQL Server 2012 is under memory pressure
SQL service

VSTS BUG: 3546396 | KB: 3013269
FIX: The result is incorrect when you run MDX query with unary operators in SSAS 2012
Analysis Services

VSTS BUG: 3720660 | KB: 3013551
FIX: SQL Server is in script upgrade mode for a long time after you apply a SQL Server hotfix or security update
SQL service

VSTS BUG: 3749034 | KB: 3013553
FIX: Insufficient memory error when you run an XML Validation Control Flow task on a large input file in SSIS 2012 or SSIS 2014
Integration Services

VSTS BUG: 3660521 | KB: 3016384
FIX: Database corruption after you perform a ProcessData and then ProcessRecalc operation in SSAS 2012
Analysis Services

VSTS BUG: 3920064 | KB: 3016518
FIX: Excel Services workbook fails to refresh using a .bism file
SQL service

VSTS BUG: 3721338 | KB: 3018713
FIX: “Internal error: An unexpected error occurred” when you run MDX query in SSAS 2012
Analysis Services

VSTS BUG: 3726428 | KB: 3019110
FIX: “Duplicate names are not allowed” error when you add multiple filters to the Power View report in SharePoint 2013
SQL service

VSTS BUG: 3727380| KB: 3020750
FIX: Error or blank page when you click the workbook link under “Data Refresh – Recent Activity”
Analysis Services

VSTS BUG: 3795803 | KB: 3021757
FIX: Duplicate sequence value is generated when you run sp_sequence_get_range in parallel with NEXT VALUE FOR function
SQL service

VSTS BUG: 3857514 | KB: 3023620
FIX: Continuous refreshes occur after you configure scheduled data refresh in PowerPivot for SharePoint 2013
Analysis Services

VSTS BUG: 3541648 | KB: 3023634
FIX: “Error converting data type nvarchar to numeric” error when you use a business rule in SQL Server 2012 MDS
MDS

VSTS BUG: 3821919 | KB: 3024790
FIX: SQL Server 2012 SP2 CU2 cannot install the SQL Writer update when the SQL Server is non-English version
Setup & Install

VSTS BUG: 3879666 | KB: 3025408
FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS 2012
Analysis Services

VSTS BUG: 3675591 | KB: 3025968
FIX: SSRS 2012 pages contain unlabeled check boxes in the detailed view
Reporting Services

VSTS BUG: 3937101 | KB: 3027214
FIX: Maintenance Plan performs offline index rebuild for large object table in SQL Server 2012
Management Tools

VSTS BUG: 3891562 | KB: 3027232
FIX: Error when you schedule data refresh by defining Secure Store ID in SQL Server 2012 PowerPivot for SharePoint 2013
Analysis Services

VSTS BUG: 3938494 | KB: 3027425
FIX: Metadata cannot be removed at publisher and synchronization time increases when you use merge replication
SQL service

VSTS BUG: 3916891 | KB: 3027860
FIX: Error 17066 or 17310 during SQL Server startup
SQL service

VSTS BUG: 3970866 | KB: 3028216
FIX: A crash occurs when proactive caching is triggered for a dimension in SSAS 2012
Analysis Services

VSTS BUG: 3833497 | KB: 3028226
FIX: Error occurs when you try to change the parameters with default values in a report in SSRS 2012
Reporting Services

VSTS BUG: 3749376 | KB: 3029126
FIX: An internal error occurs in Power View when it is used to access an SSAS 2012 multidimensional cube
Analysis Services

VSTS BUG: 3939015 | KB: 3029825
FIX: DBCC CHECKDB and DBCC CHECKTABLE take longer to run when SQL CLR UDTs are involved in SQL Server 2012
SQL performance

This update could be applied to applies to

  • Microsoft SQL Server 2012 Service Pack 2
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Analysis Services
  • Microsoft SQL Server 2012 Business Intelligence
  • SQL Server 2012 Reporting Services

    Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 4

    You may have to restart the computer after you apply this cumulative update. If you use any hybrid technology, such a Replication, AlwaysOn, Clustering:  If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP: step1: Install the service pack on the passive node / step2: Install the service pack on the active node (This step requests servicerestart).

    If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for both platforms: 64-bit and 32-bit) . This release is prepared as multilingual package. And here is the full list af all packages:

    • SQLServer2012_SP2_CU4_3007556_11_0_5569_x64 (601 MB)
    • SQLServer2012_SP2_CU4_3007556_11_0_5569_x86 (323 MB)

    Enjoy!