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