Solved

SQL Server 2008 R2 IntelliSense

Posted on 2011-09-06
12
1,310 Views
Last Modified: 2012-05-12
When I am trying to create a query the intellesense is not happening. Do I need to turn something on?
0
Comment
Question by:vbnetcoder
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
  • 2
12 Comments
 
LVL 6

Accepted Solution

by:
effes earned 250 total points
ID: 36491596
0
 

Author Comment

by:vbnetcoder
ID: 36491654
It looked mine was turned on according to what was in the article but it is still not working
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 36491857
Intellisense will only work work attaching using SQL Server 2008 (or later) tools to a SQL Server 2008 (or later) instance.  You cannot use intellisense against a 2005 instance.  If you need that, I suggest SQL prompt from Red-Gate.
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:vbnetcoder
ID: 36491963
I am using sql server 2008 r2
0
 
LVL 39

Assisted Solution

by:BrandonGalderisi
BrandonGalderisi earned 250 total points
ID: 36491982
can you run

select @@version

And post the results to verify please.
0
 

Author Comment

by:vbnetcoder
ID: 36491989
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 36492007
Cool.  And what permission level do you have in the database which you are trying to get intellisense to work?
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 36492014
Have you checked out the solution here http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/446aebe8-7889-453b-80f3-7dd3579bd19f/

1) Make sure you are connected to SQL Server 2008 Edition.
IntelliSense does not work with the previous versions of SQL Server.

2) IntelliSense should be enabled.
Go to Tools >> Options >> Text Editor >> Transact-SQL >> IntelliSense

3) IntelliSense should be refreshed with the latest changes in database.
a) Press CTRL+SHIFT+R
b) Go to Edit >> IntelliSense >> Refresh Local Cache

4) Go to Tools >> Options >> Text Editor >> Transact-SQL >> General >> IntelliSense
Select Auto List Members and Check Parameter Information.
0
 

Author Comment

by:vbnetcoder
ID: 36492029
Yes, I tried that.
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 36492879
So what are your permissions in the database then?
0
 
LVL 6

Expert Comment

by:effes
ID: 36504629
Any luck yet?

I found this thread in the MSDN Forums:
http://social.msdn.microsoft.com/Forums/en/sqltools/thread/dcd5c2cb-fc53-4c28-8b09-bfd9fea6684e

Maybe that will help.
0
 

Author Closing Comment

by:vbnetcoder
ID: 37135168
ty
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

733 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