KB3182545 - SQL Server 2016 Service Pack 1 release information

4300066

Update the copyright information to '© 2016 Microsoft' in the SQL Server command prompt installation.

Setup

5128484

Standard edition of SQL Server 2016 Analysis Services (Tabular mode) ignores the 16 GB memory limit

SSAS

5610151

Unnecessary warning message is returned in the command line output when slipstream install SQL Server with command line option.

Setup

6867499

NULL values are ignored when altering the data type of a column from text to varchar(max).

Engine

7270486

After you removed one or more updates for SQL Server, when you repair SQL Server, the repair operation fails with errors.

Setup

7330691

Adds additional information to indicate whether a report is a Mobile report to the SSRS report server execution logs.

SSRS

7350315

Install SQL Server on a computer that has a non-English domain name will fail with error 'Illegal characters in path'.

Setup

7439317

The string 'Setup Discovery Report' in the 'Installed SQL Server features discovery report' is not localized.

Setup

7439502

SQL Server 2016 installation wizard incorrectly mentioned SQL Server 2008 SP3 while SQL 2008 R2 SP3 is required.

Setup

7487320

Queries contain Row-Level Security (RLS) may fail even the DataView is set to Sample.

SSAS

7807395

You may need to retry reauthorization if data reconciliation fails on a Stretch Database enabled table.

Stretch DB

8024962

Sqlcmd quits without error if the query text contains both embedded comments and curly braces ("{" or "}").

Engine

8024968

Batch sort and optimized nested loop may cause stability and performance issues.

Engine

8024972

BCP fails with error when parse date format YYYY/MM/DD into a DATE column.

8024974

NULL values are ignored when altering the data type of a column from text to varchar(max).

Engine

8024987

Table scans and index scans with push down predicate tend to overestimate memory grant for the parent operator.

Engine

8024994

On the Complete tab, the link to the 'Surface Area Configuration' MSDN documentation is missing from the Document and Links section in a slipstream installation.

Setup

8024997

The Full-Text Search feature does not work as expected for Dutch language.

Engine

8024998

Error "Log provider 'Microsoft.LogProviderEventLog' is not installed" occurs when you open the Configure SSIS Logs: Package dialog in a SSIS package that already has a log.

SSIS

8025032

This update change the behavior that when the XML Task cannot get encoding from the XML documents, Unicode encoding will be used.

SSIS

8025058

Add the table name and Primary Key value information for error 20598 in the msdistribution_history table (SQL Server Replication)

Improvement

8025059

When a replication agent fails with query timeout, the query text is logged without enable verbose logging.

Replication

8025069

The CREATE NONCLUSTERED INDEX statement may fail if the database name begins with a '#' character.

Engine

8025081

The Replication Log Reader Agent may fail when destination table is an empty string.

Replication

8025097

Add informational messages for tempdb configurations in SQL Server error log.

Engine

8051010

The setup of SQL Server 2016 may fail if ODBC Driver 11 for SQL Server is installed during the setup.

Setup

8196154

Query execution may fail on a Stretch Database enabled table that has filter predicate specified.

Stretch DB

8210484

Affinity mask does not work correctly for NUMA nodes in SQL Server 2016 Analysis Services.

SSAS

8267453

MERGE statements that contain both UPDATE and INSERT statements fail with "Cannot insert duplicate key row" if the destination table contains unique index.

Engine

8279683

SQL Server crashes when a Tuple Mover task is terminated unexpectedly.

Engine

8281121

Improve SSAS Tabular performance scalability by implement NUMA awareness in SSAS Tabular mode.

SSAS

8292093

Create, alter or drop indexes on a table with Stretch Database enabled may fail.

Stretch DB

8343905

A slipstream installation may fail with the 'Strong name validation failed' error.

Setup

8348718

If updateenabled is set to false in a slipstream installation, the setup summary log does not contain the information of the updates installed during the installation.

Setup

8430619

Improve SSAS Tabular performance scalability by using Intel® Threading Building Blocks (Intel® TBB).

SSAS