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 ... ?