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
Last activity: Mar 14, 2019, 04:33 AM