Blog Pages

Cannot schema bind view because name 'TableName' is invalid for schema binding. Names must be in two-part format and an object cannot reference itself.

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