Cannot schema bind view MyName' because name MyTable is invalid for schema binding

I fixed the issue by adding the schema name in front of all table references:

select [..] from schema_name.table_name

If your shop is like mine and each database consists only of tables with the default schema, just add

    [dbo].

in front of each table name.


Though the Question is very old but today I too faced the same issue.

My isssue got resolved by just removing the Database name fixes the issue.

select [..] from [Database].schema_name.table_name //giving error

select [..] from schema_name.table_name //removing Database fixed the error.

Hope this help for someone.