New answers tagged indexed-view
The conflict boils down to network_activity being an Indexed View which needs to be maintained (internally) across the DML statements. That is most likely why SP1 is wanting a lock on the IX_follow-member_id_includes index as it is probably used by the View (it looks to be a covering index for the View). Two possible options: Consider dropping the ...
Top 50 recent answers are included