Does anybody know why SQL Server 2012 shows these as invalid column names even though I know they are valid and the query executes successfully? Intellisense also doesn't show me the column names as I type them out either.
Asked
Active
Viewed 3,992 times
2
-
3Press CTRL+SHIFT+R to refresh intellisense cache – Horaciux Jun 17 '14 at 14:05
-
2Try refreshing the intellisense cache with CTRL+SHIFT+R – Serpiton Jun 17 '14 at 14:05
-
It does that all the time. It's usually because the view you have open there is likely not looking at the database you opened the query from. Like, the window is looking at "master", but all the tables are in "someOtherDB". In most cases, the query will run anyway. – durbnpoisn Jun 17 '14 at 14:06
-
Have you tried refreshing your cache? CTRL + SHIFT + R? – Siyual Jun 17 '14 at 14:06
-
Thanks! CTRL+SHIFT+R did the trick! – cjwert Jun 17 '14 at 14:07
