intellisense not updating

#41

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]" <ten.xoc (AT) dnartreb (DOT) noraa> wrote

Quote:

P.S. From
http://connect.microsoft.com/SQL/fee...edbackID=33648
1

snip

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

/snip

On 8/26/08 6:11 PM, in article
B7DF67D2-AEE8-48E8-8855-9174C4A8BF07...soft (DOT) com, "Ed White"
ewhite (AT) newsgroups (DOT) nospam> wrote:

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?

#42

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]" <ten.xoc (AT) dnartreb (DOT) noraa> wrote

Quote:

P.S. From
http://connect.microsoft.com/SQL/fee...edbackID=33648
1

snip

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

/snip

On 8/26/08 6:11 PM, in article
B7DF67D2-AEE8-48E8-8855-9174C4A8BF07...soft (DOT) com, "Ed White"
ewhite (AT) newsgroups (DOT) nospam> wrote:

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?

#43

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]" <ten.xoc (AT) dnartreb (DOT) noraa> wrote

Quote:

P.S. From
http://connect.microsoft.com/SQL/fee...edbackID=33648
1

snip

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

/snip

On 8/26/08 6:11 PM, in article
B7DF67D2-AEE8-48E8-8855-9174C4A8BF07...soft (DOT) com, "Ed White"
ewhite (AT) newsgroups (DOT) nospam> wrote:

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?

#44

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]" <ten.xoc (AT) dnartreb (DOT) noraa> wrote

Quote:

P.S. From
http://connect.microsoft.com/SQL/fee...edbackID=33648
1

snip

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

/snip

On 8/26/08 6:11 PM, in article
B7DF67D2-AEE8-48E8-8855-9174C4A8BF07...soft (DOT) com, "Ed White"
ewhite (AT) newsgroups (DOT) nospam> wrote:

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?

#45

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]" <ten.xoc (AT) dnartreb (DOT) noraa> wrote

Quote:

P.S. From
http://connect.microsoft.com/SQL/fee...edbackID=33648
1

snip

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

/snip

On 8/26/08 6:11 PM, in article
B7DF67D2-AEE8-48E8-8855-9174C4A8BF07...soft (DOT) com, "Ed White"
ewhite (AT) newsgroups (DOT) nospam> wrote:

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?

#46

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]" <ten.xoc (AT) dnartreb (DOT) noraa> wrote

Quote:

P.S. From
http://connect.microsoft.com/SQL/fee...edbackID=33648
1

snip

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

/snip

On 8/26/08 6:11 PM, in article
B7DF67D2-AEE8-48E8-8855-9174C4A8BF07...soft (DOT) com, "Ed White"
ewhite (AT) newsgroups (DOT) nospam> wrote:

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?

#47

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 (AT) TK2MSFTNGP02 (DOT) phx.gbl, "Kalen
Delaney" <replies (AT) public_newsgroups (DOT) com> wrote:

Quote:

Aaron

Do you have any idea what medu is?

#48

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 (AT) TK2MSFTNGP02 (DOT) phx.gbl, "Kalen
Delaney" <replies (AT) public_newsgroups (DOT) com> wrote:

Quote:

Aaron

Do you have any idea what medu is?

#49

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 (AT) TK2MSFTNGP02 (DOT) phx.gbl, "Kalen
Delaney" <replies (AT) public_newsgroups (DOT) com> wrote:

Quote:

Aaron

Do you have any idea what medu is?

#50

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 (AT) TK2MSFTNGP02 (DOT) phx.gbl, "Kalen
Delaney" <replies (AT) public_newsgroups (DOT) com> wrote:

Quote:

Aaron

Do you have any idea what medu is?