[FIX] Sql Server Management Studio intellisense not working even its enabled
I have faced issues with SQL Server Management Studio intellisense as it was not functioining. Even I enabled intellisense but it still not showing any suggestions for autocomplete. I have followed below steps to enable SQL Server Management Studio intellisense.
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.
3. Select any database & right click on it & click on new query. Now Click on Query tab as shown below & check whether intellisense enabled or not.
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
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.
3. Select any database & right click on it & click on new query. Now Click on Query tab as shown below & check whether intellisense enabled or not.
To resolve this problem, obtain the latest Service pack for SQL Server 2008 R2
OR
To resolve this issue, install Visual Studio 2010 SP1. To download this service pack, visit the following Microsoft website: Download Visual Studio 2010 SP1
