I'm using SQL Server 2008 and I'm writing Queries in SMSS. I find that if I
add a new object (e.g. a new Table) to the database, the intellisense does
not recognize it (i.e. it puts a red underline underneath it) until I exit
SQL Server and restart it. My queries run OK even with the red underline,
but the red underline is annoying as I don't know until I run the script
whether the red underline is pointing to a real error or just hasn't updated
yet. Is there a way to refresh the intellisense without having to restart
SQL Server?

Ed White (ewhite@newsgroups.nospam) writes:

As I turn off intellisense the first thing I do when I have installed
SSMS, I cannot help with the question.

But I like to point out taht SSMS != SQL Server. If you stop and start
SSMS, you do not stop and start SQL Server. SQL Server is a server
application that could be running on a different machine. And you
definitely do not have to restart SQL Server itself, to refresh the
metadata for Intellisense. In fact, I would expect it to be sufficient
to open a new query window.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Actually, you are correct--I misspoke. I have to stop and restart SMSS, not
SQL Server, to refresh intellisense. I tried disconnecting and re-connecting
to SQL Server from SMSS hoping that would refresh, but it did not.
--
Ed

"Erland Sommarskog" wrote:

Did you try opening a new query window, like Erland suggested?

On 8/26/08 6:44 PM, in article
F48C4DD1-78E8-4E69-ABE6-67880A34DAE6@microsoft.com, "Ed White"
wrote:

P.S. From
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=33648
1



IntelliSense retrieves a snapshot of metadata from database and caches it
locally. If database metadata becomes out of sync with the cache, user needs
to flush it by using medu or CTRL+Shift+R.

Regards,
Eric Kang
SQL Server Program Manager



On 8/26/08 6:11 PM, in article
B7DF67D2-AEE8-48E8-8855-9174C4A8BF07@microsoft.com, "Ed White"
wrote:

Aaron

Do you have any idea what medu is?

--
Thanks
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
www.SQLTuners.com

"Aaron Bertrand [SQL Server MVP]" wrote in message
news:C4DA11F4.104DD%%ten.xoc@dnartreb.noraa...

It was supposed to be "menu" (bad typo I assume)...

Edit > IntelliSense > Refresh Local Cache

Questionable place for it, but I found out about it way too late to
complain. :-\

On 8/26/08 9:22 PM, in article OzONeN#BJHA.4340@TK2MSFTNGP02.phx.gbl, "Kalen
Delaney" public_newsgroups.com> wrote:

Duh... I thought what else it could possibly mean... and nothing came up for
me... now it seems so obvious.

thanks!
--
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
www.SQLTuners.com

No worries. You've caught me in a few "Duh"s too. :-)

On 8/26/08 10:13 PM, in article #AWv8p#BJHA.2480@TK2MSFTNGP02.phx.gbl,
"Kalen Delaney" public_newsgroups.com> 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.