Solved

SQL Server 2008 R2 IntelliSense

Posted on 2011-09-06
12
1,306 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

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…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

840 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