FIX: Warning and incorrect computed column results after applying hotfix 3213683 and trace flag 176

Se aplică la: SQL Server 2014 Enterprise

Symptoms


Consider the following scenario:

  • You are using Microsoft SQL Server 2014.
  • You have a table that contains at least one computed column that is not persisted and at least one computed column that is persisted.
  • You apply hotfix KB 3213683.
  • You turn on trace flag 176.

In this scenario, after you run a SELECT statement to get values from the computed column, you receive incorrect results. Additionally, you receive the following warning message:

 

Resolution


This problem is fixed in Cumulative Update 8 for SQL Server 2014 Service Pack 2 (SP2).

Workaround


To work around this issue, turn off trace flag 176.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology Microsoft uses to describe software updates.