intellisense not updating

Hi Mark,
Aaron answered my question. Ctrl-Shift-R or Edit->IntelliSense->Refresh
Local Cache from the SSMS menu fixes the problem. Opening a new query window
does not fix it.

I had tried to find something on the menu to refresh the cache, and looked
under Tools, Debug, etc., but didn't think to look under Edit. I also
searched under Help and didn't find anything on it. This message board is
great!

Thanks,
Ed


"Mark Han[MSFT]" wrote:

> Hello
>
> Thank you for contacting Microsoft Online Community Support. It is Mark, a
> SQL Server Engineer. I'm glad to assist you with the issue.
>
> For this case, you indicated that the queries run OK even with the red
> underline; you would like let the red underline disappear if the query is
> right. Is it correct? If I misunderstand anything, please tell me directly.
> It will help us to resolve this issue quickly. Once the issue resolved,
> I'll appreciate your verification.
>
> To better understand the issue, please help to confirm/collect the
> following information.
> 1) what the queries are used to do? For example: to "select" or to create a
> new table ? If it is convenient, please provide me the sample of the
> queries. I would like to try to re-produce the issue.
>
> 2) please tell me the confirguration of the intellisense in detail. Some
> screen-shot will be better.
>
> 3) To narrow down the issue, please do the following test and tell me if
> the intellisense recognize the table(under the table name, if there is a
> red line). The detail steps are below:
> a) open a new query window
> b) choose a databse (master)
> c) try to type the command " select * from dbo.spt_values " and make
> sure the table dbo.spt_values is from database
> master
>
> 4) please tell me the version/edition of the SQL Server
>
> Besides, if you would like to refresh the intellisense, please take the
> following
> Edit > IntelliSense > Refresh Local Cache
>
> Besides, my email address is v-fathan-at-online.microsoft.com(remove the
> online), you can send the information/test result via email.
>
> If you have any questions or concerns, please tell/email me.
>
> I look forward to hearing from you.
>
> Thank you
>
> Best regards,
> Mark Han
> Microsoft Online Community Support
> ================================================== =========
> Delighting our customers is our #1 priority. We welcome your
> comments and suggestions about how we can improve the
> support we provide to you. Please feel free to let my manager
> know what you think of the level of service provided. You can
> send feedback directly to my manager at: msdnmg-at-microsoft.com.
> ================================================== =========
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscripti...ult.aspx#notif
> ications.
>
> Note: The MSDN Managed Newsgroup support offering is for
> non-urgent issues where an initial response from the community
> or a Microsoft Support Engineer within 1 business day is acceptable.
> Please note that each follow up response may take approximately
> 2 business days as the support professional working with you may
> need further investigation to reach the most efficient resolution.
> The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by
> contacting Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscripti...t/default.aspx.
> ================================================== ==========
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>

Hi ED,

Thank you for the confirmation. I'm glad that the issue has been resolved.

To make issue easier to understand, I would like to explain the following.
1) IntelliSense save the information of databases in local cache. in the
instance, the information in the local cache doesn't match the real
information of the database.

2) To refresh the local cache will clear the previous information in the
cache and save the new information of the database

Hope my explanation address your concern. If anything is unclear, please
tell me.

Besides, is there anything I can assist you with the techonical issue? if
so, please email me
(v-fathan-at-online.microsoft.com)(remove the online)

Thank you again for choosing Microsoft Online Community Support.

Best regards,
Mark Han
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg-at-microsoft.com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======