This has been a longtime bug bear for me and I'm sure there's got to be a simple way to fix it.
When I create a new table or SP and refresh the database, I can see the object just fine in the object explorer. But when I'm typing a query using the newly created object the query window will say the object doesn't exist! It only seems to recognise it when I close down Management Studio and restart it.
I have tried refreshing the Intellisense cache as well but it doesn't work. Whats up with it?
Yes thats correct, the Query window will not pick up the newly created object. It underlines it in a squiggly red line and says object does not exist but the actual query will run fine because the object does exist! Its really annoying and has been like this since I can remember... why nobody has fixed this is crazy