dbTalk Databases Forums  

intellisense not updating

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss intellisense not updating in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #91  
Old   
Ed White
 
Posts: n/a

Default Re: intellisense not updating - 08-27-2008 , 03:08 PM






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:

Quote:
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 (DOT) 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 (DOT) 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.



Reply With Quote
  #92  
Old   
Mark Han[MSFT]
 
Posts: n/a

Default Re: intellisense not updating - 08-28-2008 , 09:51 PM






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 (DOT) 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 (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======


Reply With Quote
  #93  
Old   
Mark Han[MSFT]
 
Posts: n/a

Default Re: intellisense not updating - 08-28-2008 , 09:51 PM



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 (DOT) 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 (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======


Reply With Quote
  #94  
Old   
Mark Han[MSFT]
 
Posts: n/a

Default Re: intellisense not updating - 08-28-2008 , 09:51 PM



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 (DOT) 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 (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======


Reply With Quote
  #95  
Old   
Mark Han[MSFT]
 
Posts: n/a

Default Re: intellisense not updating - 08-28-2008 , 09:51 PM



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 (DOT) 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 (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======


Reply With Quote
  #96  
Old   
Mark Han[MSFT]
 
Posts: n/a

Default Re: intellisense not updating - 08-28-2008 , 09:51 PM



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 (DOT) 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 (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======


Reply With Quote
  #97  
Old   
Mark Han[MSFT]
 
Posts: n/a

Default Re: intellisense not updating - 08-28-2008 , 09:51 PM



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 (DOT) 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 (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======


Reply With Quote
  #98  
Old   
Mark Han[MSFT]
 
Posts: n/a

Default Re: intellisense not updating - 08-28-2008 , 09:51 PM



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 (DOT) 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 (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======


Reply With Quote
  #99  
Old   
Mark Han[MSFT]
 
Posts: n/a

Default Re: intellisense not updating - 08-28-2008 , 09:51 PM



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 (DOT) 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 (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======


Reply With Quote
  #100  
Old   
Mark Han[MSFT]
 
Posts: n/a

Default Re: intellisense not updating - 08-28-2008 , 09:51 PM



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 (DOT) 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 (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.