• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 78
  • Last Modified:

SQL Server 2008R2

Hi,

I am having difficulty  not getting intellisense in SQL Server 2008 R2 . I have attached a screenshot.When I try to query for example adventureworks table, the drop down in intellisense shows databases but not tables and its associated columns and thus the sql queries appear in red. I have gone to option section, edit section..and made sure that the intellisense is turned on. I even downloaded Servicepacks for SQL Server 2008R2 and it didnt work. Please help.

Thanks in advance.
sql-2008R2-issue.PNG
0
techEverest
Asked:
techEverest
1 Solution
 
Mike EghtebasDatabase and Application DeveloperCommented:
USE Adventureworks;
Are you connected to the database?

Have recently installed visual studio? If so, checkout: http://support.microsoft.com/kb/2531482
0
 
techEverestAuthor Commented:
I did do all that, use adventureworks, offcourse connected to the database. I am getting query outputs but the intellisense is not working ..I dont want to guess but get help on column names etc..when i type period after a table name..nothing pops up. Have not installed visual studio either..
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
For starters, is it enabled?  Tools:Options, then follow the below imageintellisense.jpg
If you've recently added objects, you'll have to refresh for IntelliSense to pick up those changes.
Edit > IntelliSelse > Refresh Local Cashe
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
techEverestAuthor Commented:
Hi eghtebas/ Jim,

I did try all of the above that you mentioned before I posted my issue. I am really surprised why this is happening. I attached Adventureworks db few months back and just wanted to practice some SQL query but this issue is annoying. without the intellisense , its not easy querying the database.
0
 
Anthony PerkinsCommented:
More than likely the database is a SQL Server 2005 database or (I am not sure about this) you have the compatibility level set to 90.
0
 
techEverestAuthor Commented:
Anthony,

I have SQL Server 2008R2 and the adventureworks2008R2 as well. I have attached screenshot for your reference.In the screenshot please see the query where I am trying to use SELECT statement and get records from HumanReosurce table. You can see that I am not able to get the table in the intellisense drop down lists..
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Are you working in the context of the AdventureWorks database? Check the database name that is selected in the top toolbar of the SSMS.
0
 
LIONKINGCommented:
Probably something you tried, but, have you tried refreshing the intellisense cache?
Edit >> IntelliSense >> Refresh Local Cache (usually the keyboard shortcut is Ctrl + Shift + R).
0
 
techEverestAuthor Commented:
I have tried all of the above before i posted my question. I am working in the contrxt of adventureworks db. even though the intellisense is not working, query runs and output is there. Just need to see intellisense working which makes life easier
0
 
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
What is the access level of the login you are using to connect to your SQL Server instance? Does Intellisense work if you are logged in with someone who is a member of the sysadmin fixed server role which also has full access to the database? (I'm just trying to figure out if your login has sufficient permissions to enumerate through all objects).
0
 
techEverestAuthor Commented:
Nakul,

Thanks for reminding that. I right clicked on sql server and ran as administrator, after that the intellisense worked. I am the adminstrator in my local machine  but not sure why right click was required. This solved the issue. Thanks everybody.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now