Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

Free SQL Server Webcast > Building Really Fast SQL Server VMs
 

Enabling IntelliSense and Refreshing IntelliSense Data in SSMS 2008


By:   |   Read Comments (12)   |   Related Tips: 1 | 2 | More > SQL Server Management Studio

Problem

There may be times when IntelliSense in SQL Server Management Studio 2008 is not working or does not display the latest schema changes. To resolve these issues you can follow the below solution.

Solution

One of the new features of SSMS 2008 is IntelliSense. IntelliSense is a feature which reads internal metadata and provides a list of available objects and properties while you are writing T-SQL. Sometimes IntelliSense does not work when using SQL Server Management Studio 2008. To fix this you can follow the below steps.

Step 1: Go to Tools > Options > Text Editor > Transact-SQL > IntelliSense and make sure the Enable IntelliSense checkbox is checked

resoloving issues when intellisense in ssms 2008 is not working

Step 2: To verify that it is enabled, go to the Query menu and check that IntelliSense is enabled as shown below.

make sure the enable intellisense checkbox is checked

Step 3: If you are unable to see the IntelliSense for the latest schema changes then from a query window, go to Edit -> IntelliSense -> Refresh Local Cache. You can also use the Ctrl + Shift + R shortcut to refresh the cache.

edit intellisense if you are unable to see the intellisense for the latest schema changes

Next Steps
  • Use this tip to refresh the IntelliSense data for newly created objects
  • Remember you can use the CTRL + SHIFT + R shortcut when you change database objects
  • Note: IntelliSense does not work for earlier versions of SQL Server prior to SQL Server 2008


Last Update:


next webcast button


next tip button



About the author
MSSQLTips author Jugal Shah Jugal Shah has 8+ years of extensive SQL Server experience and has worked on SQL Server 2000, 2005, 2008 and 2008 R2.

View all my tips





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Tuesday, December 22, 2015 - 11:57:09 AM - Alejandro Piņon Back To Top

Does Intellisense MSSQL2008 work in Management Studio 2014? 

 


Wednesday, January 15, 2014 - 12:27:33 PM - Barry Seymour Back To Top

I am stuck using SQL 2005 but I like SSMS 2008, so I use the free add on dbForge SQLComplete from DevArt. The free express version provides excellent Intellisense. Go to http://www.devart.com/dbforge/sql/sqlcomplete/ and click the 'Free Edition' tab at the bottom. Very, very nice.

 

 


Friday, March 01, 2013 - 9:24:57 AM - Asser Back To Top

Hi

I'm using SQL Server 2008 R2, intellisense was working fine before I installed Visual Studio 2010 SP1.

After the install, it stopped working. I followed the steps as indicated above it still doesn't work. sigh!

 


Thursday, February 21, 2013 - 6:21:37 AM - srujana Back To Top

I did all the settings mentioned above still It is not working. I am using SQL server 2008 R2.


Wednesday, September 12, 2012 - 5:21:14 PM - Jugal Back To Top

Hi Ram,

I hope you are not connecting the SQL Server 2005 or any other lower versions from the SSMS 2008, if so intellisense will not work with lower versions. 

Please follow the steps mentioned above and restart the SSMS, you can even use CTRL + SHIFT + R shortcut whenever you add new object to database.

 

Thanks,

Jugal Shah

 


Wednesday, September 12, 2012 - 5:54:47 AM - Ram Back To Top

hi

  i am using sql server 2008 R2 but still intellisense is not working i am enable all tools which is you show above..

 autocomplete intelllisense is not working ...

 like  write query

"select * from users"  then table name comes on list... but it is not occur..

please give me suggation


Wednesday, March 14, 2012 - 4:12:35 AM - Nageswar Back To Top

Download and install
Microsoft® SQL Server® 2008 R2 Service Pack 1


Wednesday, February 29, 2012 - 8:06:16 PM - Hila DG Back To Top

Brilliant! Thanks!

I've been looking for this tip all over the place!


Wednesday, February 02, 2011 - 2:02:47 AM - Jugal Shah Back To Top

Yes Vikash, It will not support to SQL Server 2005.


Wednesday, February 02, 2011 - 1:36:11 AM - Vikash Kumar Singh Back To Top

Nice tip..Thanks a lot...I do not have a SQL Server 2005 but are you sure it does not work with SQL Sever 20005(as mentioned in your tips that it works with SQL Server 2008 and later version?


Tuesday, February 01, 2011 - 10:21:58 AM - Jugal Shah Back To Top

Thanks Armando


Tuesday, February 01, 2011 - 9:40:10 AM - Armando Prato Back To Top

Thanks for the tip!  I've just started in SQL 2008 and I've been lazy about figuring out the Intellisense features.


Learn more about SQL Server tools