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


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.


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


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


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