Restored database from .bkp file in SQL Server 2014 generates some strange errors I have restored the well-known Northwind database and executed a trivial query:



Notice the strange error "Invalid object name..." although the query has been executed successfully and both tables can be seen in Object Explorer.

Is there an explanation for this?
The errors have nothing to do with the fact that the database is restored (in fact they aren't even errors, just intellisense being flaky).

As you can see in the dropdown top left and the status bar (in yellow) you are executing your query against the master database.

Either change your database in the dropdown or execute a USE mydatabasename;.

As noted by Aaron Ctrl-shift-R refreshes the intellisense but that could take a while before taking effect.