Intellisense broken?

Question

Intellisense broken?

Brandie Tarvin

SSC Guru

Points: 172994
More actions
December 11, 2017 at 7:04 am

#326928

Up until about a week ago, Intellisense on my SSMS worked fine. Now it's still working but for some reason only brings up SQL System functions. It doesn't prompt me for table names / columns / aliases anymore. Not even system tables. Like when I'm searching Information_Schema. It used to prompt me for that right after I started typing it, but it doesn't anymore.
Any thoughts on what I might have done to break it?
I've had issues with typing lately as I'm trying to code with one hand while holding a baby in the other. It's caused quite a few keyboard snafus and I think this might have been one of them.
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
May 16, 2018 at 8:51 am

This was removed by the editor as SPAM
June 8, 2018 at 5:10 am

This was removed by the editor as SPAM

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Sue_H SSC Guru Points: 90860 More actions · Answer 1

Brandie Tarvin - Monday, December 11, 2017 7:04 AM
Up until about a week ago, Intellisense on my SSMS worked fine. Now it's still working but for some reason only brings up SQL System functions. It doesn't prompt me for table names / columns / aliases anymore. Not even system tables. Like when I'm searching Information_Schema. It used to prompt me for that right after I started typing it, but it doesn't anymore.
Any thoughts on what I might have done to break it?
I've had issues with typing lately as I'm trying to code with one hand while holding a baby in the other. It's caused quite a few keyboard snafus and I think this might have been one of them.

Did you turn off statement completion - check tools, options, text editor, all languages, general - check the autolist and parameter settings in the statement completion section.

Sue

Brandie Tarvin SSC Guru Points: 172994 More actions · Answer 2

Those are both still checked.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Brandie Tarvin SSC Guru Points: 172994 More actions · Answer 3

This is aggravating. Shortly after posting the above, Intellisense starts working again. I wonder if the act of opening the window and looking "fixed" the problem.

This after almost 2 weeks for googling and finding nothing...

Always always always the tech starts working when the real troubleshooting begins.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Sue_H SSC Guru Points: 90860 More actions · Answer 4

Brandie Tarvin - Monday, December 11, 2017 10:44 AM
This is aggravating. Shortly after posting the above, Intellisense starts working again. I wonder if the act of opening the window and looking "fixed" the problem.
This after almost 2 weeks for googling and finding nothing...
Always always always the tech starts working when the real troubleshooting begins.

It definitely is flakey - I have weird issues come and go all the time with SSMS since the separate download was introduced. That and finding features that aren't supported with SSMS on lower versions of SQL Server.
I've googled the intellisense issues as well as the mouse pointer issues more than I care to remember. I think it may be related to VsHub.exe and/or the different versions of Visual Studio. Intellisense doesn't look to be too stable with plain VS users either. That's where I found most of the posts about Intellisense just stopping to work. So I don't think it's you.

Sue

Brandie Tarvin SSC Guru Points: 172994 More actions · Answer 5

Sue_H - Monday, December 11, 2017 11:10 AM
So I don't think it's you.
Sue

That's good to hear. Thanks, Sue.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Jeff Moden SSC Guru Points: 1003853 More actions · Answer 6

Heh... you titled this post "Intellisense broken?"

My answer is "Yes... just like always". 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Brandie Tarvin SSC Guru Points: 172994 More actions · Answer 7

Jeff Moden - Monday, December 11, 2017 2:14 PM
Heh... you titled this post "Intellisense broken?"
My answer is "Yes... just like always". 😉

Hee. Okay, maybe that was a bad choice of subject. Might explain why no one else was paying attention to it. 😉

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Grant Fritchey SSC Guru Points: 398679 More actions · Answer 8

Intellisense works fine as long as you only ever use SQL Prompt.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Brandie Tarvin SSC Guru Points: 172994 More actions · Answer 9

Smooth, Grant. Very smooth!

I applaud how you slid that in there.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Grant Fritchey SSC Guru Points: 398679 More actions · Answer 10

Brandie Tarvin - Tuesday, December 12, 2017 6:27 AM
Smooth, Grant. Very smooth!
I applaud how you slid that in there.

Thanks. Just trying to be helpful.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Luis Cazares SSC Guru Points: 183698 More actions · Answer 11

I've experienced problems with Intellisense when the connection is slow or the database is too large. Try refreshing the cache and give it some time to do it.
Or you can spend the big bucks and follow Grant's advice, but where's the fun when you make it so easy? 😛
That reminds me, I have to request my Redgate's toolbelt.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2