I am getting the error Msg 11404, Level 16, State 1, Line 2 ALTER TABLE SWITCH statement failed. Target table XXXX is referenced by 10 indexed view(s), but source table XXX' is only referenced by 5 matching indexed view(s). Every indexed view on the target table must have at least one matching indexed view on the source table. when trying to switch destination table to source table. I have checked that all indexes are the same in both source and destination tables plus dependencies and also in the same file group. Also checked the constraints and they are all fine. What are the other possible issues that I should be on the look out for? Thanks again! C!