What is SQL Server Management Studio intellisense
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.
1. Connect to your SQL Server 2008.
2. Go to Tools-> Options-> Text Editor-> Transact-SQL->IntelliSense & make sure all below settings are enabled as shown below.
If intellisense does not work even after above steps then you need follow below steps to start intellisense option.
To resolve this problem, obtain the latest Service pack for SQL Server 2008 R2
To resolve this issue, install Visual Studio 2010 SP1. To download this service pack, visit the following Microsoft website: Download Visual Studio 2010 SP1