• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 532
  • Last Modified:

Invalid Object Name

I have a strange issue. I created a view, and I can select data from the view, but in Query window, the name of the view is marked with red underline and show invalid object name while mouse on it.

What happened here? I use 2008 R2 version. I can successfully create a store procedure with using this view, but this view name and columns from this view are marked red underline too. How does the issue happen? Seems like a SQL server tool bug ... ?
0
minglelinch
Asked:
minglelinch
1 Solution
 
didnthaveanameCommented:
Try Ctrl+Shift+R to refresh intellisense's local cache.
0
 
minglelinchAuthor Commented:
Thank you.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now