Solved

SQL Server 2008 R2 IntelliSense

Posted on 2011-09-06
12
1,302 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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 

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

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
Get Duration of last Status Update 4 35
sql Total query 2 27
ORA-00923: FROM keyword not found where expected 3 66
Extract string portion 2 24
     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
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…

803 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