Solved

SQL Server 2008 R2 IntelliSense

Posted on 2011-09-06
12
1,297 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
  • 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
 

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
[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

 
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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now