Sample Header Ad - 728x90

Can SQL Server disable IntelliSense on SSMS?

4 votes
1 answer
2434 views
I am using SSMS 2016 (ver: 13.0.15000.23) and connecting to SQL Server database 2016 (ver: 13.0.5081.1). IntelliSense is not working on my SSMS. I tried the following: * Tools >> Options >> Text Editor >> Transact-SQL >> IntelliSense, and select Enable IntelliSense * Tools >> Options >> Text Editor >> Transact-SQL >> General, and verify Auto list members and Parameter information check boxes are checked * Query >> IntelliSense Enabled * Verify that SQLCMD is disabled * Refreshed IntelliSense cache (Ctrl+Shift+R) * Making sure no compile errors are in the query * Uninstall and reinstall SSMS I asked other members in my team and IntelliSense only works sporadically for them, if it does. **Question:** Is there a server setting which is disabling IntelliSense on SSMS? --- I've already gone through all of these questions: * https://dba.stackexchange.com/q/6145/32970 * IntelliSense is not working at SQL Server Management Studio * Why is SQL Server 2008 Management Studio Intellisense not working? * SQL Server Intellisense not working on *some* servers * SQL Server 2008 R2 intellisense doesn't work * https://dba.stackexchange.com/q/90475/32970 I have limited permissions on the instance, but I can select and update records in the database I'm working in (I didn't try insert). I can see around 1,600 names of objects and columns by running: SELECT o.name, c.name FROM sys.objects o INNER JOIN sys.columns c ON o.object_id = c.object_id WHERE o.is_ms_shipped = 0;
Asked by Farhan (291 rep)
Nov 20, 2018, 04:16 PM
Last activity: Mar 14, 2019, 04:33 AM