Invalid object name SQL Server 2008 R2 – Stored procedure

It’s SSMS, not SQL Server. If it’s an error against the database engine you’ll know it (it wouldn’t execute the command successfully).

Solution

You need to refresh the Intellisense cache (Ctrl + Shift + R). Or you can go to Edit -> IntelliSense -> Refresh Local Cache.