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

Symptoms

Assume that you have an indexed view that uses the SUM() function in Microsoft SQL Server 2012. After you perform an insert or delete operation on the base table, the view returns incorrect results.

Resolution

The issue was first fixed in the following cumulative update of SQL Server: 

Cumulative Update 7 for SQL Server 2012 SP2
About cumulative updates for SQL Server

Status

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

Properties

Article ID: 3068439 - Last Review: Jul 21, 2015 - Revision: 1

Feedback