SQL SERVER – IntelliSense Does Not Work – Enable IntelliSense

While I was working with SQL Server 2008 IntelliSense, I realized that it was not functioning as I expected. Even after I had enabled IntelliSense it was still not opening any suggestions at all. After a while, I figured out some vital information regarding how to make sure IntelliSense smoothly works all the time without you giving any trouble. Let us learn how we can Enable IntelliSense.

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.

SQL SERVER - IntelliSense Does Not Work - Enable IntelliSense Int1

2) IntelliSense should be enabled.
There are two ways to verify whether IntelliSense is enabled or not.
a) From Toolbar

SQL SERVER - IntelliSense Does Not Work - Enable IntelliSense Int2b

b) Go to Tools >> Options >> Text Editor >> Transact-SQL >> IntelliSense

SQL SERVER - IntelliSense Does Not Work - Enable IntelliSense Int2a

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

SQL SERVER - IntelliSense Does Not Work - Enable IntelliSense Int3

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

SQL SERVER - IntelliSense Does Not Work - Enable IntelliSense Int4

Let me know what you think of this blog post. Did you face this problem ever? I am very confident by following this tip, you will be able to solve your problem with IntelliSense.

Reference : Pinal Dave (https://blog.sqlauthority.com)

, , , ,
Previous Post
SQLAuthority News – Top 10 Strategic Technologies for 2009
Next Post
SQL SERVER – Reseed Identity of Table – Table Missing Identity Values – Gap in Identity Column

Related Posts

164 Comments. Leave new

Leave a Reply

Menu