November 27, 2009 at 2:12 am
Ive been experiencing a strange problem inside sql server 2008 management studio.
On my local server I created a database, using the table creation wizard i created a simple table (just 3 columns), saved it, at which point it appears in the list of tables in the database. I then open a new query window and start to type some SQL. Intellisense just wont work for the newly added table !
typing dbo. brings up a list of previously added tables, but not the new one. If i type the name in anyway, the query editor underlines it in red and hovering over it shows a message
'invalid object name dbo.prefix' ** prefix is the name of the newly added table
If i type in
Select * from prefix the query works but I still get the table underlined in red with the error message above
Ive tried refreshing the database, but it makes no difference. The only way to get intellisense to recognise the new table is to shut down management studio !
Is this a known bug ?
November 27, 2009 at 2:45 am
Your problem is that the intellisense cache must be refreshed, before it recognizes new objects. Just hit Ctrl+Shift+R and it will work.
[font="Verdana"]Markus Bohse[/font]
November 27, 2009 at 2:57 am
thats great, thanks.
November 27, 2009 at 4:48 am
MarkusB (11/27/2009)
Your problem is that the intellisense cache must be refreshed, before it recognizes new objects. Just hit Ctrl+Shift+R and it will work.
Something I didnt know, thanks for that Markus 🙂
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply