February 27, 2014 at 8:55 am
When writing my queries in SQL Managament Studio 2008R2, the columns from the table i am querying are not showing up as suggestions for me to select. Any thoughts?
February 27, 2014 at 8:58 am
Sorry
February 27, 2014 at 8:58 am
- Check it's enabled.
- If it is, try refreshing the local cache (Edit> Intellisense > Refresh Local Cache)
February 27, 2014 at 8:59 am
Have you tried "Edit" > "Intellisense" > "Refresh local Cache"
?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 27, 2014 at 9:06 am
yes i have tried to refresh the local cache and no different
February 27, 2014 at 9:15 am
Are you connecting to a 2008 server? I don't remember if it'll work with a 2005 server but with 2000 it won't.
February 27, 2014 at 9:17 am
This is SQL 2008 R2.
February 27, 2014 at 9:29 am
Has it ever worked for you on that instance?
February 27, 2014 at 9:31 am
No it has never worked. This is a new install of the program on my machine
February 27, 2014 at 9:32 am
This happened to one of our developers.
We tried everything with the intellisense setup with multiple reboots. No luck.
He had to reinstall SSMS to get it to work. Not saying this will help you, but that is how his worked.
February 27, 2014 at 10:58 am
1. Are any of your databases offline?
2. What happens when you press Ctrl-J?
3. What compatibility level is the database? If it's an earlier version of SQL Server, intellisense may not work
Check here for a good list of things you can try:
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 27, 2014 at 11:13 am
installing the SP1 solved my issue. Thanks:-D
February 27, 2014 at 12:02 pm
I almost said that but could not remember. :hehe:
February 28, 2014 at 3:55 am
If you really want to see how intellisense ought to work, check out Red Gate SQL Prompt[/url].
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
February 28, 2014 at 5:54 am
Grant Fritchey (2/28/2014)
If you really want to see how intellisense ought to work, check out Red Gate SQL Prompt[/url].
Remember Grant is the "Product Evangelist for Red Gate Software" 🙂 😀
All jokes aside, we use SQLPrompt as well - it's pretty nifty.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply