Question: has unresolved reference to object?
Answer: The "unresolved reference to object" in a stored procedure is a warning, but for the function it is an error. The error fails the build and consequently the schema compare and update of the database. The error normally is caused by a query that references an object on other database.