I know there are a lot of posts on this issue, however I am unable to find a resolution to my issues.
Running: SMS 2014 with CU1 - Version 10.0.2342.0 on both SSMS and Client Tools. Visual Studio 2010 SP1 - 10.0.40219.1 SP1Rel
Connecting to: Server 2008 R2 SP2 CU 5 - 10.50.4276
Have Verified: IntelliSense in enabled. SQLCMD Mode is disabled. Have Refreshed Cache. Verified IntelliSense settings. Server does not support contained databases so this was ruled out.
Behavior:
Intellisense autopopulates and functions normally. All the tables are listed and the additional databases on the server.
Neither parameters or tables autopopulate and CTRL-J does not do anything.
Anyone have any other ideas to try? SSMS 2008 R2 worked fine across all the databases.
IntelliSense is not available when the Query Editor is connected to earlier versions of the Database Engine. IntelliSense is turned off in the Database Engine Query Editor when the SQLCMD mode is set on.
Enable statement completion: please go to Tools >> Options >> Text Editor >> Transact-SQL >> General, and check on Auto list members and Parameter information boxes. Refresh IntelliSense local cache: please go to >> Edit >> IntelliSense >>Refresh Local Cache or use the CTRL+Shift+R keyboard shortcut to refresh.
On the Tools menu, click Options. Expand Text Editor, expand Transact-SQL, and then click IntelliSense.
Visual Studio 2010 Shell is installed with SQL Server 2014 and 2012 - SQL Server | Microsoft Learn.
You could try refreshing the local cache by pressing CTRL + Shift + R buttons and wait for a while.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With