Questions tagged [intellisense]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
15 views

How to remove the red squiggly line from IntelliSense for Queues

I know you can force SQL Server Management Studio to update the IntelliSense cache, but the red squiggly line for Service Broker Queues does not go away by updating the cache. It's not a big deal, but ...
1
vote
0answers
23 views

SQL Server Permissions for Intellisense for an Active Directory User? [duplicate]

I have created an Active Directory Group and created it as a user, we'll call it "AD SQL", in my DB. I can successfully login in using Active Directory Authentication and read/write. However, ...
1
vote
0answers
363 views

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 ...
4
votes
1answer
683 views

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 ...
0
votes
1answer
922 views

How to remove the red squiggly line from IntelliSense for the newly created table or procedure without restarting the SSMS [duplicate]

A newly created table or procedure will always have the red squiggly underline until the SQL Server Management Studio is restarted. Is there a way to get rid of it without re-start the SSMS? Or it's a ...
1
vote
2answers
885 views

How to make IntelliSense understand temp tables, linked servers and synonyms?

I'm using SSMS 17.6 which is the latest version at the time of posting. It is supposed to have the latest official IntelliSense version. However, it underlines my scripts with red squiggles where I'm ...
-1
votes
1answer
209 views

SQL Management Studio Intellisense - Hide global variables

I am not sure if this is possible, but when writing a query to select from a table, when I bring up the intellisense drop down with CTRL + Spacebar, it gives me a list of all variables (global, and on ...
1
vote
0answers
37 views

Hide tables from SSMS Intellisense

Is it possible to hide tables or other objects from popping up on SSMS' IntelliSense? For example, I have the following tables Patient Patient_history Patient_daily I would like to only see ...
0
votes
2answers
956 views

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

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 ...
3
votes
3answers
261 views

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 ...
1
vote
2answers
296 views

SSMS Intellisense spamming error log

I'm seeing thousands of rows in our error log about failed logins: Error: 18456, Severity: 14, State: 38. Login failed for user 'Ourcompany\myaccount'. Reason: Failed to open the explicitly ...
1
vote
1answer
1k views

SQL Server Management Studio 2014 12.0.5000.0 “Invalid Column Name” Error [duplicate]

The following code executes as expected. However, the editor shows red lines under attribute5 and WCC_ID in "h.attribute5 = i.WCC_ID" and states "Invalid column name" when the mouse hovers over the ...
1
vote
2answers
2k views

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 ...
0
votes
1answer
523 views

Intellisense not working for one connection but works for others

I can connect to multiple database servers. Intellisense works on all of the connections except one. It used to work on this connection also until recently. I did the following: Enable Intellisense (...
0
votes
1answer
130 views

Restored database from .bkp file in SQL Server 2014 generates some strange errors [closed]

I have restored the well-known Northwind database and executed a trivial query: Notice the strange error "Invalid object name..." although the query has been executed successfully and both tables can ...
1
vote
1answer
76 views

Is there a way to add “distinct” to SSMS IntelliSense?

For the last few versions of SSMS (SQL Server Management Studio), I have noticed that IntelliSense does not contain the word distinct. Is there a way I can add this to the IntelliSense word bank? ...
5
votes
2answers
7k views

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 ...
1
vote
0answers
83 views

SSMS 2012 intellisense is not working on one of the servers?

I dont know if this question is asked - I found similar question - How to enable intellisense, but my case is little different. We have 2 SQL Servers 2012 - one is in the other room, other is in our ...
4
votes
1answer
85 views

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 ...
3
votes
1answer
1k views

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 ...
1
vote
0answers
518 views

Can I implement Intellisense into my stored procedure with custom constants?

I created a stored proc to do some cleanup on some orphaned temp tables by issuing a DROP. However, I want to vary the time threshold so I have a stored procedure that accepts a time unit (e.g. hours, ...
5
votes
1answer
1k views

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: ...
1
vote
1answer
167 views

SSMS Intellisense - Data Dictionary Incorporation - Show Object Descriptions in Popup? [closed]

Can anyone point me in the right direction for an SSMS intellisense replacement that will show the object descriptions in the popup? This will help speed up onboarding as well as making myself ...
1
vote
2answers
3k views

Intellisense in SSMS 2012 not working for 2008 server

I did most of the solutions provided here. I know about enabling IntelliSense clearing the cache connecting to a server >= SQL Server 2008 using the latest SQL Server Service Pack and it works ...
2
votes
1answer
770 views

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 ...
23
votes
1answer
14k views

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 ...
30
votes
7answers
114k views

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 ...
4
votes
1answer
515 views

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 ...
4
votes
3answers
136 views

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....