Questions tagged [intellisense]
The intellisense tag has no usage guidance.
36
questions
0
votes
1
answer
67
views
Sql server Intellisense is not working
My sql server management studio intellisense is not working, below is my SSMS version and screen shot that I have tried, my SQL server is not installed locally but I am accessing the sql server ...
0
votes
1
answer
48
views
public role restrictions on a shared server prevent IntelliSense from working
I have an SQL Server 2016 database. This database is hosted on a shared server, and is managed by a central DBA team. In an effort to harden data security on the Production server, the DBA team has ...
- 119
2
votes
1
answer
900
views
Azure Data Studio - intellisence do not see tables in schema other than dbo
Do you know any way to force intellisence in Azure Data Studio to find tables in custom schemas?
As you can see I have tables:
dbo.TableC
schemaA.TableB
When typing a query, only TableC is found by ...
- 121
2
votes
2
answers
199
views
In SSMS, are IntelliSense and SQLCMD mode mutually exclusive?
In SSMS, are IntelliSense and SQLCMD mode mutually exclusive?
Is there any way to make IntelliSense work when SQLCMD mode is enabled? (I use SQLCMD a lot)
I'm trying to understand why IntelliSense ...
- 133
7
votes
2
answers
6k
views
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 ...
- 73
1
vote
0
answers
311
views
Intellisense not working over VPN
I'm running SSMS 2019 on my laptop, connecting to 2 different SQL Servers - 2008 R2 and a SQL 2016 machine. When I'm physically in the building where the servers reside, Intellisense works great. But ...
- 11
0
votes
1
answer
119
views
SSMS IntelliSense not working with sa user
In SSMS (versions 17 and 18), IntelliSense is not working with the sa user, but it is working with another user.
If I connect to a SQL database with the sa user and create a query window, IntelliSense ...
- 1
0
votes
0
answers
50
views
SQL Server System Objects and Intellisense
I have created two stored procedures that I want to be available from all databases on SQL Server 2017. I created them in the master database, used sp_ as the prefix for both of them (e.g. sp_MyProc1 ...
- 61
1
vote
0
answers
185
views
IntelliSense is not woking SQL Server 2017 [closed]
I am using SQL Server 2017 and I had already installed Visual Studio 2019 before installing SQL Server. Sometimes when I create the first table in a database it gives me IntelliSense for that first ...
- 107
1
vote
0
answers
84
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, ...
- 11
3
votes
1
answer
1k
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 ...
- 131
4
votes
1
answer
2k
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 ...
- 241
1
vote
1
answer
14k
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 ...
- 151
1
vote
3
answers
3k
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 ...
- 213
1
vote
1
answer
589
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 ...
3
votes
2
answers
5k
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
3
answers
354
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 ...
- 693
1
vote
2
answers
395
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 ...
- 2,153
1
vote
1
answer
2k
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 ...
- 11
3
votes
2
answers
4k
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 ...
- 133
0
votes
1
answer
671
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
1
answer
257
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 ...
- 77
1
vote
1
answer
143
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?
...
user66242
5
votes
2
answers
8k
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 ...
user66242
1
vote
0
answers
123
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 ...
- 1,163
4
votes
1
answer
124
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 ...
- 4,418
3
votes
1
answer
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 ...
- 143
1
vote
0
answers
713
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, ...
- 552
5
votes
1
answer
2k
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:
...
- 71
1
vote
1
answer
191
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 ...
- 26
1
vote
2
answers
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 ...
- 851
2
votes
1
answer
812
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 ...
- 123
26
votes
1
answer
17k
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 ...
- 629
35
votes
8
answers
146k
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 ...
- 41.7k
4
votes
1
answer
520
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 ...
- 809
4
votes
3
answers
143
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....
- 1,485