March 11, 2010 at 5:04 am
Hi,
In SQL Server Management Studio, Observed there's something i would like to know.
I logged in as "sa" user. I created the table and tried to access the table. It is working fine..
But, why it is showing invalid object as ToolTip Text which is confusing.
Why is it so?? do we need to do anything??
Thanks in advance.
March 11, 2010 at 5:16 am
Refresh the IntelliSense cache.
You can do this by pressing Shift+Ctrl+R, or from the menu: Edit->IntelliSense->Refresh Local Cache.
It may take a few seconds to rebuild.
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
March 11, 2010 at 5:18 am
This was removed by the editor as SPAM
March 11, 2010 at 5:43 am
stewartc-708166 (3/11/2010)
Intellisense takes a while to synchronise added / changed / removed metadata.
It only seems to refresh my cache if I disconnect and reconnect to the server. If it does refresh periodically, I've never noticed it.
Do you know of any documentation relating to this? I cannot see anything in Books Online.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
March 11, 2010 at 10:38 pm
This was removed by the editor as SPAM
March 12, 2010 at 12:01 am
I think the disconnect reconnect method is about the best way to refresh it. It seems to be most consistent for me.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 12, 2010 at 1:00 am
CirquedeSQLeil (3/12/2010)
I think the disconnect reconnect method is about the best way to refresh it. It seems to be most consistent for me.
Jason...CTRL + SHIFT + R! :w00t:
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
March 12, 2010 at 1:04 am
Paul White (3/12/2010)
CirquedeSQLeil (3/12/2010)
I think the disconnect reconnect method is about the best way to refresh it. It seems to be most consistent for me.Jason...CTRL + SHIFT + R! :w00t:
Was that CTRL + SHIFT + R?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 12, 2010 at 1:46 am
CirquedeSQLeil (3/12/2010)
Paul White (3/12/2010)
CirquedeSQLeil (3/12/2010)
I think the disconnect reconnect method is about the best way to refresh it. It seems to be most consistent for me.Jason...CTRL + SHIFT + R! :w00t:
Was that CTRL + SHIFT + R?
No. [font="Arial Black"]CTRL + SHIFT + R[/font]
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
March 12, 2010 at 12:14 pm
Paul White (3/12/2010)
CirquedeSQLeil (3/12/2010)
Paul White (3/12/2010)
CirquedeSQLeil (3/12/2010)
I think the disconnect reconnect method is about the best way to refresh it. It seems to be most consistent for me.Jason...CTRL + SHIFT + R! :w00t:
Was that CTRL + SHIFT + R?
No. [font="Arial Black"]CTRL + SHIFT + R[/font]
[font="Arial Black"]THANKS[/font]:hehe:
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 12, 2010 at 7:04 pm
CirquedeSQLeil (3/12/2010)
Paul White (3/12/2010)
CirquedeSQLeil (3/12/2010)
Paul White (3/12/2010)
CirquedeSQLeil (3/12/2010)
I think the disconnect reconnect method is about the best way to refresh it. It seems to be most consistent for me.Jason...CTRL + SHIFT + R! :w00t:
Was that CTRL + SHIFT + R?
No. [font="Arial Black"]CTRL + SHIFT + R[/font]
[font="Arial Black"]THANKS[/font]:hehe:
[font="Arial Black"]
Y
O
U
A
R
E
W
E
L
C
O
M
E
[/font]
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
March 14, 2010 at 12:59 pm
Thanks 🙂
March 14, 2010 at 3:53 pm
Not as elaborate as Paul, but you're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 14, 2010 at 9:47 pm
CirquedeSQLeil (3/14/2010)
...but you're welcome.
Same here.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply