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.