The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
41 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
54 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 ...
0
votes
1answer
28 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? ...
3
votes
0answers
198 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
35 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
42 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
702 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 ...
0
votes
0answers
113 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, ...
2
votes
1answer
406 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
104 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
618 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 ...
14
votes
4answers
43k 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
476 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
123 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 ...