In this post, we want to discuss the IntelliSense feature in SSMS. Before we get started, if you want to know about how to update the first table from the second table record, please go through the following article: Update table from another table in SQL Server.
Assume that you install Microsoft Visual Studio 2010 Service Pack 1 (SP1) on a computer that has Microsoft SQL Server 2008 R2 RTM and Cumulative Update 1 through 6 for Microsoft SQL Server 2008 R2 installed. In this situation, the IntelliSense feature in Microsoft SQL Server 2008 R2 Management Studio (SSMS 2008 R2) may stop working.
Note: The IntelliSense feature provides suggestions for how to complete SQL queries. Additionally, the feature provides query validation when you create SQL queries in a query window in SSMS. When this issue occurs, SSMS 2008 R2 does not provide suggestions for how to complete queries and does not highlight errors in SQL queries by using red wavy lines.
After installing VS 2010 SP1, Intellisense stopped working in SQL Server Management Studio SSMS 2008 and R2 databases. After searching on the net, I found that this issue is being discussed on this thread and an MS support guy Weilin Qiao has given the following suggestion:
Go to Tools > Options > Text Editor > Transact-SQL > IntelliSense, and select Enable IntelliSense.
For each opening query window, please go to Query >> Intellisense Enabled.
To refresh IntelliSense local cache, go to Edit > IntelliSense > Refresh Local Cache or use the CTRL+Shift+R keyboard shortcut to refresh.
Enable statement completion: Go to Tools > Options > Text Editor > Transact-SQL > General, and check on Auto list members and Parameter information boxes.
Reboot SQL Server Management Studio.
I have tried the suggestions without much success and probably I will uninstall Sp1 and reinstall it again. I will update this post once I am able to figure this out! If you have a solution that works, please share it with the readers.