Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [intellisense]

35 questions
36
votes
8 answers

IntelliSense not working but it is enabled

This problem is really proving to be a tricky one (and quite annoying). In SQL Server Management Studio 2008, up until a few days ago my IntelliSense was working great. Then all of a sudden it stopped. The icon as it as enabled on the toolbar…
Thomas Stringer
  • 42,434
  • 9
  • 120
  • 155
27
votes
1 answer

How can I force SQL Server Management Studio to update the IntelliSense cache?

IntelliSense in SSMS isn't updating unless I shut it down and restart. I've tried disconnecting from the server and reconnecting while the SSMS session is active, but that isn't working. Steps to recreate: Create a table Select something from…
Head of Catering
  • 659
  • 2
  • 10
  • 24
18
votes
2 answers

Azure Data Studio - Intellisense does not detect tables, yet queries work. How do I fix this?

Okay. So I'm breaking some new ground and trying to get into Azure Data Studio. I'm having a problem with intellisense that seems to be a bug with Azure Data Studio but I'm not sure. I have issues with basic queries. Foreign keys, select…
Krausladen
  • 199
  • 1
  • 1
  • 6
5
votes
1 answer

SSMS IntelliSense doesn't work on particular database

I have SSMS 2014 installed on my desktop, and many 2012 and 2014 databases running in our data center. So far I found one database (database A) doesn't have IntelliSense working, for exampletyping: SELECT [put cursor here] FROM sys.objects and…
AlbertZOZ
  • 71
  • 5
5
votes
2 answers

How to fix SQL Server Management Studio 2014 IntelliSense when intermittent

Our remote SQL Server was recently upgraded to 2014. I installed SQL Server Management Studio 2014 on my Windows 10 client computer. At first, everything seemed to be going great, until I noticed that IntelliSense is intermittent. By "intermittent"…
user66242
4
votes
1 answer

SQL Server 2008 and Management Studio - Intellisense is Patchy

I'm working off an SQL 2008 instance that sits on our intranet. All is fine except that sometimes intellisense is there and working and sometimes it isn't. Its a pretty fast network so I don't imagine its a case that the RDBMS is reactively…
immutabl
  • 809
  • 2
  • 7
  • 16
4
votes
1 answer

Can SQL Server disable IntelliSense on SSMS?

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…
Farhan
  • 291
  • 1
  • 3
  • 8
4
votes
3 answers

Is there any trick that allows to use Management Studio's (ver. 2008) IntelliSense feature with earlier versions of SQL Server?

Latest version of Management Studio (i.e. the one that ships with SQL Server 2008) finally has a Transact-SQL IntelliSense feature. However, out-of-the-box it only works with SQL Server 2008 instances. Is there some workaround for this? [I asked…
Marek Grzenkowicz
  • 1,495
  • 2
  • 18
  • 27
4
votes
1 answer

Configure SSMS intellisense / web browser settings to accept UNC directory path inputs

I would like to navigate to open a directory path from an in-line commented UNC path. SSMS integrates with Windows Explorer and Explorer allows UNC navigation from the address bar. Indeed, when in the integrated browser, it is possible to navigate…
Peter Vandivier
  • 5,485
  • 1
  • 25
  • 49
3
votes
1 answer

IntelliSense is enabled but not working in SQL Server 2016 with Azure SQL DB

I have installed SQL server 2016 whose details are as in below screenshot: My queries are pointing to Azure SQL DB. Below are the screenshot of some other settings that I have found over the internet and applied: I have also tried by refreshing…
I Love Stackoverflow
  • 131
  • 4
3
votes
2 answers

Why is SSMS showing red squigglies(sp?) even though the table exists?

I'm creating a new table and in the process creating two foreign keys. The tables with the primary keys referenced exist but Intellisense is giving the error message: "Foreign key. . .references invalid table 'ROLES'." Why does SQL Server Management…
IEnjoyEatingVegetables
  • 351
  • 1
  • 3
  • 15
3
votes
3 answers

Intellisense not working because of code creating columnstore index

I use SQL Server 2016 Developer Edition on Windows 10 64 bit. All the databases are local on my laptop. I have a SQL script file, and Intellisense doesn't work on it. I have enabled Intellisense and tried various fixes suggested in this…
Jason
  • 683
  • 1
  • 12
  • 26
3
votes
2 answers

How to permanently fix IntelliSense poor functioning on SSMS?

I have literally installed on my development machine three different versions of SSMS standalone: 2008, 2012, 2014, and I work with SQL Server 2008 databases. On every single one of those versions, I tried to have IntelliSense display my available…
Renato
  • 133
  • 1
  • 5
3
votes
1 answer

Intellisense is not working since upgrade to SQL Server 2014

We recently upgraded our production server to SQL Server 2014. This server hosts ~2200 databases. When I connect to it as sa with SQL Server Management Studio 2014 and I type queries, Intellisense does not work (nothing show up). Before the upgrade,…
MaxiWheat
  • 143
  • 7
2
votes
1 answer

IntelliSense alternative using SSMS 2012 in a contained database as a contained user?

According to this answer about contained database disadvantages: If you connect to a contained database as a contained user, SSMS will not fully support IntelliSense. You'll get basic underlining for syntax errors, but no auto-complete lists or…
scw
  • 123
  • 3
1
2 3