Error message:
Cannot schema bind view 'dbo.ViewName' because name 'TableName' is invalid for schema binding. Names must be in two-part format and an object cannot reference itself.
Cause and solution:
Call tables with the schema name: dbo.TableName (not only TableName).
It's can happen in indexed views query.
No comments:
Post a Comment