<div>
<div class="content wysiwyg-content">
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. <br />
<br />
What happened here? I use 2008 R2 version. I can <b>successfully </b>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 ... ?
</div>
</div>


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

Invalid Object Name

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).