Enabling IntelliSense and Refreshing IntelliSense Data in SSMS 2008

By: Jugal Shah | Read Comments (6) | Print Jugal has 8+ years of extensive SQL Server experience and has worked on SQL Server 2000, 2005, 2008 and 2008 R2. Related Tips: More

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

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

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.

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

Related Tips: More | Become a paid author

Last Update: 2/1/2011

Share:

Share

Tweet

Free SQL Server Learning The SQL Server Security THREAT - It’s Closer Than You Think Tutorial - SQL Server Performance Tuning and Monitoring

Comments and Feedback:

Tuesday, February 01, 2011 - 9:40:10 AM - Armando Prato	Read The Tip
Thanks for the tip!  I've just started in SQL 2008 and I've been lazy about figuring out the Intellisense features.

Tuesday, February 01, 2011 - 10:21:58 AM - Jugal Shah	Read The Tip
Thanks Armando

Wednesday, February 02, 2011 - 1:36:11 AM - Vikash Kumar Singh	Read The Tip
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?

Wednesday, February 02, 2011 - 2:02:47 AM - Jugal Shah	Read The Tip
Yes Vikash, It will not support to SQL Server 2005.

Wednesday, February 29, 2012 - 8:06:16 PM - Hila DG	Read The Tip
Brilliant! Thanks! I've been looking for this tip all over the place!

Wednesday, March 14, 2012 - 4:12:35 AM - Nageswar	Read The Tip
Download and install Microsoft® SQL Server® 2008 R2 Service Pack 1

Post a Comment or Question

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name

*Email

Notify for updates

Comments *** NOTE *** - If you want to include code from SQL Server Management Studio (SSMS) in your post, please copy the code from SSMS and paste the code into a text editor like NotePad before copying the code below to remove the SSMS formatting.
*Enter Code

 

Sponsor Information

"SQL diagnostic manager delivers response in minutes, not hours!" It takes just 5 minutes to connect your SQL Databases to source control. Got 5 minutes? Get started now. SQL Servers keeping you up at night? Contact the Edgewood SQL Server consultants for a Health Check. Find and Fix SQL issues with Foglight Performance Analysis. Get a free copy. Join the over million SQL Server Professionals who get their issues resolved daily. Valuable SQL Server web casts on Performance Tuning, Development, Administration, SSIS and more...