[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 2012 SP2 Cumulative Update #9 is available!

Week ago SQL Server Release Services Team released new update package for SQL Server 2012.

This update (VSTS BUG: 5285719 | 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 Cumulative Update No 9 {build no 11.0.5641.0) for SQL Server 2012 with Service Pack 2, Microsoft fixed twelve issues:

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

VSTS BUG: 5514346 | 3103293
FIX: Error 17066 occurs during the encryption operation when you use TDE in SQL Server 2012
SQL service

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

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

VSTS BUG: 5686787 | 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
SQL service

VSTS BUG: 5641871 | 3103016
FIX: SSRS stops responding when you try to export a report to a .pdf document in SQL Server 2012
Reporting Services

VSTS BUG: 4272469 | 2682488
FIX: Backup operation fails in a SQL Server database after you enable change tracking
SQL service

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

VSTS BUG: 5646993 | 3097636
FIX: Performance decrease when an application that has connection pooling frequently connects or disconnects in SQL Server
SQL service

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

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

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

 

This update could be applied for:

  • Microsoft SQL Server 2012 Service Pack 2

 

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 9

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!

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

Newest update for SQL Server 2012. This time for SQL Server 2012 with Service Pack 2. In this Cumulative Update No 8 {build 11.0.5634.1} Microsoft released over twenty four bugs and issues. Here is the list of fixed issues:

VSTS BUG: 5020090 | 3081074
FIX: A stalled dispatcher system dump forces a failover and service outage in SQL Server 2014 or SQL Server 2012
High Availability

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

VSTS BUG: 5051432 | 3080209
FIX: Error 602 when you run a stored procedure repeatedly in SQL Server 2012
SQL performance

VSTS BUG: 5137914 | 3087094
FIX: It takes longer time than expected when you run query with non-admin user role in SSAS 2012 in Tabular model
Analysis Services

VSTS BUG: 4933177 | 3087114
FIX: PowerPivot for SharePoint doesn’t run automatic data refresh on the first day of each month
Analysis Services

VSTS BUG: 5469866 | 3087920
FIX: Excel crashes when you use Excel 2010 on a computer that has the .NET Framework 4.6 installed
Analysis Services

VSTS BUG: 5153046 | 3088480
FIX: Data spill occurs when you sort large amount of data in SQL Server 2012
SQL performance

VSTS BUG: 5161111 | 3080856
FIX: Information disclosure when you create session cube by using dynamic role-based security in SQL Server 2012
Analysis Services

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

VSTS BUG: 5510259 | 3089527
FIX: FileStream Share Access fails when you use AlwaysOn Availability Groups feature in SQL Server 2012
High Availability

VSTS BUG: 5484835 | 3089687
FIX: Can’t export empty Tablix header in CSV file when NoHeader is false in SSRS 2012
Reporting Services

VSTS BUG: 5067331 | 3090049
FIX: Transparent Data Encryption certificate can’t be created in SQL Server 2012
SQL security

VSTS BUG: 4259067 | 3054180
FIX: It may take longer than expected to create a SQL Server LineString instance in SQL Server 2014 SP1
SQL service

VSTS BUG: 5047154 | 3077273
FIX: Rare incorrect result occurs when you run parallel query in SQL Server 2012
SQL service

VSTS BUG: 5038253 | 3092702
FIX: It takes a longer time than earlier versions of SQL Server when you run DBCC CHECKDB in SQL Server 2012
SQL service

VSTS BUG: 5174510 | 3092703
FIX: Access violation occurs in AlwaysOn availability groups scenarios in SQL Server 2012
SQL performance

VSTS BUG: 5535001 | 3087872
FIX: Access violations when you use the FileTable feature in SQL Server 2012
SQL service

VSTS BUG: 5078154 | 3081580
FIX: “String or binary data would be truncated” error when you use peer-to-peer replication in SQL Server 2012
SQL service

VSTS BUG: 5586474 | 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: 5502135 | 3093869
FIX: SQLDiag fails with function 87 error in SQL AlwaysOn scenario where the server name has 15 characters
Management Tools

VSTS BUG: 5014318 | 3088307
FIX: Scheduler deadlock on primary replica when you remove a replica from an AlwaysOn availability group in SQL Server 2012
High Availability

VSTS BUG: 5127984 | 3091643
FIX: Error occurs when you configure SQL Server replication or set up a linked server in SQL Server 2012
SQL security

VSTS BUG: 4484245 | 3095156
FIX: Error 9002 and error 3052 when you try to add or back up log file in SQL Server 2012
High Availability

 

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

  • Microsoft SQL Server 2012 Service Pack 2

 

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 8

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:

    SQL Server 2012 | ql11Sp2Cu8x64
    SQL Server 2012 | Sql11Sp2Cu8x86

Enjoy!