Blog Pages

Errors while Indexed View creation

Here are fer errors (and solutions...) while Indexed View creation.

Error: 
Cannot schema bind view because name is invalid for schema binding. Names must be in two-part format and an object cannot reference itself
Solution:
Add schema to the objects names.

Error:
Cannot schema bind view 'dbo.MyView'. 'dbo.OtherView' is not schema bound.
Solution:
Use tables, not views. 
Another solution: Create the other views 'WITH SCHEMABINDING' also.

Error: 
Cannot create index on view . The view contains a self join on
Solution:
Sorry, no solution...... :-(

No comments:

Post a Comment