SQL Server - Intellisense - Asked By Ramachandran on 13-Nov-11 02:41 AM

Intellisense mode is not working in my sql server but is showing the status as intellisense enabled plse help for enabling that Intellisense mode
Suchit shah replied to Ramachandran on 13-Nov-11 02:50 AM

Given below are four different ways through which you can enable IntelliSense.

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.
There are two ways to verify whether IntelliSense is enabled or not.
a) From Toolbar

b) 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.


Neha Garg replied to Ramachandran on 13-Nov-11 02:53 AM
Hello Ramachandran,

I'm assuming that you're using the feature against a SQL version:

Install the below mentioned files. It will helps you....

you will need to install Cumulative Update package 7 for SQL Server by requesting SQLServer2008R2_RTM_CU7_2507770_10_50_1777_x86or

SQLServer2008R2_RTM_CU7_2507770_10_50_1777_x64

Kirtan Patel replied to Ramachandran on 13-Nov-11 03:04 AM
there can be two reasons for it 
  1. The object is not in the local IntelliSense cache, since it was created recently. You can fix this easily by going to Edit > IntelliSense > Refresh Local Cache, or CTRL+SHIFT+R
  2.  The query window is connected to a down level server (e.g. SQL Server 2005), where IntelliSense does not function 
Jitendra Faye replied to Ramachandran on 13-Nov-11 11:51 PM
Reference from-

http://msdn.microsoft.com/en-us/library/ms173434%28SQL.90%29.aspx

There are certain cases when the IntelliSense options may not work as you expect:

  • There is a code error above the cursor.
    If there is an incomplete statement or other coding error above the location of the insertion point, IntelliSense may be unable to parse the code elements and therefore will not work. You can comment out the applicable code to enable IntelliSense again.
  • You are inside a code comment.
    IntelliSense options are not available if the insertion point is within a comment in your source file.
  • You are inside a string literal.
    IntelliSense options are not available if the insertion point is inside the quotation marks around a string literal, as in:
    WHERE FirstName LIKE 'Patri%|'
  • The automatic options are turned off.
    Many IntelliSense features work automatically by default, but you can disable any feature.
    Even when automatic statement completion is disabled, you can invoke an IntelliSense feature. For more information, see http://msdn.microsoft.com/en-us/library/ms173743%28v=SQL.90%29.aspx.