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

Two update packs has been released by Microsoft for SQL Server stack. First package is for SQL Server 2012 Service Pack 2. In this Cumulative Update No 10 {build no 11.0.5644.2} Microsoft fixed eleven bugs listed below.

This update (VSTS BUG: 5285700 | 321185) introduces a new global property that exposes the latest CU number that is currently installed on the SQL Server. After you install this update, you can obtain the CU number information by executing either of the following queries:

          SELECT @@VERSION
          SELECT SERVERPROPERTY(‘PRODUCTUPDATELEVEL)

Additionally, this update also adds the CU number information to the first line of the SQL Server error log.

VSTS BUG: 6200864 | 3052404
FIX: You cannot use the Transport Layer Security protocol version 1.2 to connect to a server that is running SQL Server 2014 or SQL Server 2012
SQL service

VSTS BUG: 5794926 | 3135749
FIX: Incorrect group members are obtained when you execute the xp_logininfo stored procedure in SQL Server
SQL security

VSTS BUG: 5680960 | 3095626
FIX: “No such interface supported” error occurs when you click a parameter drop-down list in a SSRS report or a CRM report
Reporting Services

VSTS BUG: 6091773 | 3109051
FIX: Default settings are used when you print to a non-default printer in SQL Server 2012 Reporting Services
Reporting Services

VSTS BUG: 6346685 | 3125526
FIX: You receive errors when you execute a query that uses tempdb in SQL Server
SQL service

VSTS BUG: 6091565 | 3120595
FIX: Column data is deleted when you update another column in a table in SQL Server 2012
SQL service

VSTS BUG: 6384783 | 3123309
FIX: The Log Reader Agent stops intermittently and an Access Violation occurs in SQL Server 2012
SQL service

VSTS BUG: 6413081 | 3123089
FIX: The INSTEAD OF trigger uses a different collation than the contained database in SQL Server 2012
SQL performance

VSTS BUG: 6293637 | 3132058
FIX: Error occurs when you try to drop or delete filegroups or partition schemes and functions in SQL Server
SQL service

VSTS BUG: 6400183 | 3132062
FIX: The SMK initialization fails on one node of SQL Server failover cluster in SQL Server 2012
SQL security

VSTS BUG: 5912517 | 3123485
FIX: Slow performance occurs when you run MDX query in SSAS 2012
Analysis Services

 

This update could be applies to:

  • Microsoft SQL Server 2012 SP2

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 10

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.

List ofpackages:

  • SQL12SP2QFECU10\x64\SQLServer2012-KB3120313-x64.exe | 649.0 MB
  • SQL12SP2QFECU10\x86\SQLServer2012-KB3120313-x86.exe | 358.7 MB

Small change which is already implemented for downloading prosess – you will get The Latest Update (by default):

image

Enjoy!

[EN] SQL Server 2012 SP3 Cumulative Update #1 is available!

Two update packs has been released by Microsoft for SQL Server stack. Second package is for SQL Server 2012 Service Pack 3. In this Cumulative Update No 1 {build no 11.0.5644.2} Microsoft fixed seven bugs – all for SQL Service – listed below.

This update (VSTS BUG: 5285700 | 321185) introduces a new global property that exposes the latest CU number that is currently installed on the SQL Server. After you install this update, you can obtain the CU number information by executing either of the following queries:

          SELECT @@VERSION
          SELECT SERVERPROPERTY(‘PRODUCTUPDATELEVEL)

Additionally, this update also adds the CU number information to the first line of the SQL Server error log.

VSTS BUG: 6200864 | 3052404
FIX: You cannot use the Transport Layer Security protocol version 1.2 to connect to a server that is running SQL Server 2014 or SQL Server 2012
SQL service

VSTS BUG: 6551412 | 3135750
FIX: SQL Server may crash when a request for execution of a remote stored procedure contains incomplete definition of arguments
SQL service

VSTS BUG: 6346687 | 3125526
FIX: You receive error messages when you run a query that uses tempdb in SQL Server
SQL service

VSTS BUG: 6372590 | 3132545
FIX: The STRelate and STAsBinary functions return unexpected results when trace flag 6533 is enabled in SQL Server 2012 Service Pack 3
SQL service

VSTS BUG: 6227298 | 3133055
An update to enable the “-k” startup parameter to control the rate that work files can spill to tempdb is available for SQL Server 2012 Service Pack 3
SQL service

VSTS BUG: 6223281 | 3125525
FIX: The CHANGETABLE function in a query returns incorrect results when Change Tracking is enabled for a SQL Server database
SQL service

VSTS BUG: 6609943 | 3100451
FIX: “Invalid cursor position” error when you retrieve spatial data by using SQLSetPos in SQL Server 2014 or SQL Server 2012
SQL service

This update could be applies to:

  • Microsoft SQL Server 2012 SP2

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 1

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.

List ofpackages:

  • SQL12SP3QFECU1\x64\SQLServer2012-KB3123299-x64.exe | 585.8 MB

  • SQL12SP3QFECU1\x86\SQLServer2012-KB3123299-x86.exe | 309.7 MB

Small change which is already implemented for downloading prosess – you will get The Latest Update (by default):

image

Enjoy!

[EN] SQL Server 2014 SP1 Cumulative Update #4 is available!

In December SQL Server Release Services Team released two update packs. Both for SQL Server 2014. First Cumulative Update no 4 {build no 12.0.4436.0} is for SQL Server 2014 with Service Pack 1. Microsoft change update methodolody for SQL Native Clinet (SNAC) fixes – more on my other post {HERE}

This update (VSTS BUG: 5285700 | 321185) introduces a new global property that exposes the latest CU number that is currently installed on the SQL Server. After you install this update, you can obtain the CU number information by executing either of the following queries:

          SELECT @@VERSION
          SELECT SERVERPROPERTY(‘PRODUCTUPDATELEVEL)

Additionally, this update also adds the CU number information to the first line of the SQL Server error log.

In this update packs Microsoft fixed over thirty five bugs and below you will find list of fixed errors with KB articles numbers.

VSTS BUG: 5873983 | 3107431
FIX: Arbitrary shape multi-select query ignores scoped calculations and returns unexpected results in SSAS
Analysis Services

VSTS BUG: 5814789 | 3099548
FIX: Can’t create database snapshot when you use DBCC CHECKDB in SQL Server 2014
SQL service

VSTS BUG: 5951427 | 3115789
FIX: Memory leak occurs on MEMOBJ_SOSNODE type object when you run query in sys.database_permissions in SQL Server 2014
SQL service

VSTS BUG: 6174897 | 3119197
FIX: Access violation occurs when you update compressed data in SQL Server 2014
SQL service

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

VSTS BUG: 6279778 | 3097636
FIX: Performance decrease when application with connection pooling frequently connects or disconnects in SQL Server
SQL service

VSTS BUG: 6279792 | 3103644
SQLTables function and sp_tables stored procedure don’t require SELECT permission any longer on user tables and views
SQL security

VSTS BUG: 6279801 | 3103472
FIX: SQL Server service performs more I/O operations on the mirror server than on the principal server
High Availability

VSTS BUG: 5832700 | 3103998
FIX: Access violation occurs when you run INSERT, UPDATE or MERGE statement on view with check option in SQL Server 2014
SQL performance

VSTS BUG: 6279787 | 2835348
Update improves the Service Broker when you send messages to remote servers in SQL Server 2012 and SQL Server 2014
SQL service

VSTS BUG: 6070032 | 3108537
FIX: DBCC CHECKFILEGROUP reports false inconsistency error 5283 on database with partitioned table in SQL Server 2014
SQL service

VSTS BUG: 5853862 | 3070382
FIX: SQL Server 2014 crashes when you run a remote query in a stored procedure by using an invalid user name
SQL service

VSTS BUG: 5851894 | 3123068
FIX: Log shipping restore job takes a long time on the secondary server in SQL Server 2014
SQL service

VSTS BUG: 5853868 | 3112710
FIX: Performance is slow when you open and read event files (.xel) by using XEvent Linq reader in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 5858196 | 3124043
FIX: Query stops responding in SQL Server 2014 that starts with trace flag 2430 as startup parameter
SQL service

VSTS BUG: 6032889 | 3124048
FIX: “Invalid computer host name in the FileTable path” error when you use GetPathLocator function in SQL Server 2014
High Availability

VSTS BUG: 6028817 | 3107346
FIX: Access violation and restart of SQL Server occur when you alter an extended events session in SQL Server 2014
SQL service

VSTS BUG: 6279769 | 3097970
FIX: Sp_describe_undeclared_parameters returns incorrect result when the undeclared parameter targets a decimal column
SQL service

VSTS BUG: 5715114 | 3081150
FIX: Orientation setting is lost when you export a report to a Word document in SSRS 2012 or SSRS 2014
Reporting Services

VSTS BUG: 5723831 | 3106976
FIX: An access violation occurs when you use the TDE and BPE features in SQL Server 2014
SQL service

VSTS BUG: 5825257 | 3029825
FIX: DBCC CHECKDB/CHECKTABLE command may take longer in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 5853864 | 3081757
FIX: Error occurs when you try to view the property of the contained database in SQL Server 2014
Management Tools

VSTS BUG: 5853867 | 3098529
FIX: Assertion Failure when you change the type of a column in SQL Server 2014
SQL service

VSTS BUG: 6207411 | 3101120
FIX: SQL Server stops responding when you back up the certificate that is used to encrypt the database encryption key in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 5715077 | 3082877
FIX: No error is prompted when connection is ended in sqlcmd
SQL service

VSTS BUG: 6279798 | 3102243
FIX: The version and version flag properties of subscription view can’t be updated correctly in MDS 2012 or MDS 2014
Master Data Services (MDS)

VSTS BUG: 6181589 | 3113071
FIX: The SubscriptionStreams parameter is ignored by Distribution Agent in transactional replication in SQL Server 2014
SQL service

VSTS BUG: 5181896 | 3052461
FIX: All attributes in element are ignored when you transform XML file in SSIS 2012 or SSIS 2014
Integration Services

VSTS BUG: 5181926 | 3063438
FIX: Both XSD validation and XSLT transformation fail when you run an SSIS 2014 package that contains multiple concurrent XML tasks
Integration Services

VSTS BUG: 6223597 | 3123448
FIX: Error occurs when you try to start Report Builder for SSRS 2014 from Report Manager
Reporting Services

VSTS BUG: 6190109 | 3124049
FIX: The execution of stored procedure is replicated to subscriber incorrectly from Publisher in SQL Server 2014
SQL performance

VSTS BUG: 6279794 | 3051145
FIX: SQL Server may shut down when you use Service Broker in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 5699005 | 3110497
FIX: The query stops responding when you run a parallel query on the table with a columnstore index in SQL Server 2014
SQL service

VSTS BUG: 5833830 | 3075468
FIX: Temporary files that are created by DBCC aren’t deleted when SQL Server is restarted
SQL service

 

This update could be applied to:

  • Microsoft SQL Server 2014 Service Pack 1

 

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.

Enjoy!