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.
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.
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)
165 Comments. Leave new
@ Eric Russell. Great catch!! Thanks for the fix Eric, very annoying bug. You just saved me a bunch of time.
Installing SP1 fixed this for me — on Two machines!
SP1 for SQL 2008 R2, can be found here:
http://www.microsoft.com/en-us/download/details.aspx?id=26727
I have tried all the above suggestions and Intellisense does not work. All the other developers have it working on their machine but mine won’t. SQLCMD is turned off. Intellisense is turned on. Auto List Members and Parameter Information are turn on.
heyy please help me, i want to install both sql server 2008 SP2 and visual studio 2010 ultimate, but i did’nt understand which software i need to install first
to avoid further installation errors……what should i do???????
Everyhting above didnt work for me, except to install the SP1 of SQL server 2008R2… After i installed it it worked immediately.. So everyone… do install the SP1…
After some Windows/Office/VS2008/VS2010 updates, as well as some updates for TFS, I lost Intellisense (again). I couldn’t install SQL2008 SP1 again for some strange reason but SP2 installed fine…and I now have it working again!
http://www.microsoft.com/en-us/download/details.aspx?id=30437
Thanks for this very useful post!
open on dev edition 64 bit machine
not on std edition at all , done all steps above
if all regular setting have been done but it still doesn’t work, u might need to install sp1 for sql server 2008
I also had a data base offline. As soon as I took it on-line or deleted it, Intellisense worked again.
Found new solution which is a variation of Donna’s suggestion. Even though my Windows login is an Administrator, I ran SSMS as Administrator, disabled Intellisense, closed SSMS, opened SSMS as Administrator, and enabled Intellisense. Intellisense now works for me, regardless whether I run SSMS as Administrator. Previously, same process without running SSMS as Administrator had failed to resolve issue for me.
Had the problem today… fixed it.
– Make sure your db dropdown points to the correct db! Sometimes you do something and you look and it’s pointing to master or some other db…
awesome, thank you sir.
Hi, Today I Installed SQL Server 2008 service pack 2, Now Intellisense is working perfectly.
I have tried all the options which you define above but intelliscence still not working please help, I’m using sql2008R2 (10.50RTM)
My problem was not solve still,what can i do pls suggest?
I’m using sql2008R2 (10.50RTM)
I have tried all of the mentioned steps and I still cant get Intellisense to work.
SQL 2008 (10.0 SP3)
It was working and then all of a sudden it stopped.
Any other suggestions. Wven when I checked to see if the databases were offline teh Bring online was greyed out
Thanks Dave!
Really Cool post mate!
Best Wishes,
~salman~
Simply running the following latest update to SQL Server (Service Pack 2) fixed everything for us. Enjoy.
http://download.microsoft.com/download/3/D/C/3DC6663D-8A76-40A6-BCF2-2808C385D56A/SQLServer2008R2SP2-KB2630458-x86-ENU.exe
i have used all step u metioned above still Intellisense is not working
Thanks, nice Work , it solves my problem…