SQL Server Management Studio - Invalid Object

The "Ghost" Error (IntelliSense)

SSMS has a background process called IntelliSense that parses your code as you type to provide those red squiggly underlines and auto-completion.

• The Problem: IntelliSense uses a local cache of your database schema. If you just created the procedure 30 seconds ago, the cache doesn't know it exists yet.

• The Result: When you type ALTER, IntelliSense looks at its "old" list, doesn't see the procedure, and flags it as an error—even though the SQL Engine knows exactly where it is.

The Fix: Press Ctrl + Shift + R to refresh the IntelliSense cache. The red lines should disappear.