Solved

Tables don't show up in query editor

Posted on 2011-09-15
3
319 Views
Last Modified: 2012-05-12
Hi,

I'm developing with sql server 2008 express. When I create a new table the table doesn't show up directly in the query window when I create a query with intellisence activated. Older tables are there but it takes al long time (often a day or so) until the newly created tables show up for intellisence in the query window.

I've tried to refresh the tables view and also gone to Edit/Intellisence/Refresh Local Cache, but still they don't show up until a long while later. I also restarted the service for sql server without result.

How can I make them available directly instead of hours later.

Peter
0
Comment
Question by:peternordberg
  • 2
3 Comments
 
LVL 17

Expert Comment

by:dbaSQL
ID: 36542314
right-click on the Tables and Select Refresh, or hit Ctrl-shift+R, to refresh intellisense
0
 

Author Comment

by:peternordberg
ID: 36542327
Hi and thanks foir answer,

As I said above I've already tried both those options already, but that doesn't solve it.

Peter
0
 
LVL 17

Accepted Solution

by:
dbaSQL earned 500 total points
ID: 36542357
apparrently this is somewhat of a 'feature'.  surprises me, though, that the refresh doesn't get it for you.  is that what you're saying?  see here:

http://blogs.msdn.com/b/dtjones/archive/2008/09/11/refreshing-the-intellisense-cache.aspx
http://cherupally.blogspot.com/2009/12/how-to-get-sql-server-2008-intellisense.html

0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSAS Hierarchy with columns with folder names 10 19
LAG_ROWID - how do I get the right order using this query? 2 15
AJAX pass along a variable 3 46
Trouble with <> 2 20
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question