title: When indexed view updated
body: <p>I create a indexed view <code>View1</code> on <code>Table1</code> and <code>Table2</code> and have instead of trigger and after trigger on <code>Table1</code> that use of <code>View1</code>. It seem that data of <code>View1</code> not change when I use this view on instead of trigger and after trigger. But I want to use <code>View1</code> with new data when use this view on after trigger. How can I do it. It should be noted that I use <code>with Noexpand</code> hint when use indexed view (when don't use <code>with noexpand</code> hint in <code>SQL Server 2008 R2</code> act this indexed view such as no indexed view).</p>