Indexed view is not updated on data changes in base table - by ellight1

Status : 

  Duplicate<br /><br />
		This item appears to be a duplicate of another existing Connect or internal item.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 771336 Comments
Status Closed Workarounds
Type Bug Repros 3
Opened 11/15/2012 11:50:58 PM
Access Restriction Public


Data in an indexed view (index) does not changes after table update.
This bug was reproduced in concrete use of MERGE.
The problem can be avoided by editing trigger in 2 ways:
- replacing MERGE with simple UPDATE,
- or cutting "WHEN NOT MATCHED" from MERGE

Link on russian forum:

Also tested on:
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4263.0 (X64) 
Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64) 
Sign in to post a comment.
Posted by Tharindu Dhaneenja on 11/6/2013 at 12:03 AM
Thanks for the information. more information on SQL Server Merge command hope this will help you all,
Posted by Alexey [MSFT] on 12/12/2012 at 7:49 PM
Thanks for your time reporting the issue.
Please, note this problem is known and was actually fixed in SQL Server 2008 SP3 Cumulative Update 8 (see
The fix will also be available in SQL Server 2008 R2 SP1 Cumulative Update 10, SQL Server 2008 R2 SP2 Cumulative Update 4, SQL Server 2012 Cumulative Update 5 and SQL Server 2012 SP1 Cumulative Update 2 when they release.
I will be resolving the issue as a duplicate of a known hotfix.

    SQL Server Development