Solved

Invalid Object Name

Posted on 2013-06-13
2
518 Views
Last Modified: 2013-06-14
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
Comment
Question by:minglelinch
2 Comments
 
LVL 8

Accepted Solution

by:
didnthaveaname earned 500 total points
ID: 39245623
Try Ctrl+Shift+R to refresh intellisense's local cache.
0
 
LVL 1

Author Closing Comment

by:minglelinch
ID: 39248678
Thank you.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question