I just imported a database for my SQL server DB project. In that few queries are used 3 part object reference syntax. Which is referencing the same database. When I am compiling it gives me the below error
SQL71561: view [view Name ]has an unresolved reference on [table name]
Database name : TestDB
View Name : TestView
Table Name: TestTable
Error in view descrription : Select * from TestDB.dbo.TestTable
Here the 3 part "TestDB.dbo.TestTable" giving me the error though still from the same database. It is not a cross db query.