SSMS - turn off Auto Complete via space / spacebar

[Isaac]

In SQL Server Management Studo, I want to only turn off that particular facet of auto complete/intellisense where the spacebar triggers the auto complete

I am using:

SQL Server Management Studio 15.0.18386.0 (aka v18.9.2)
SQL Server Management Objects (SMO) 16.100.46437.65
Microsoft Analysis Services Client Tools 15.0.19618.0
Microsoft Data Access Components (MDAC) 10.0.19041.1
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.19042

I can't seem to find it, but feel sure I have turned it off before - although that may have been in ssms 2012, or it may not have been so stupid in 2012, I can't remember which.

 

[Minty]

I think you need to use this;

If not have a look here https://dba.stackexchange.com/questions/20068/suppress-sql-server-management-studio-auto-complete

 

[Isaac]

Yeah I had looked at that thread and tried the solution you pictured as well, it didn't seem to help in this particular version. I definitely don't want to turn off intellisense entirely or anything like that. And I tried the toggling and it didn't seem to work, since I'm not really using control Alt just the spacebar alone. They really shouldn't have designed it that way, utilizing the enter key would have been more than adequate. Using the space bar is a ridiculous design because of course once you're done typing what you want, then you want to ignore intellisense and hit the spacebar to continue typing more things! What a mess. I'll dig around a little bit more and see if I'm mistaken in one of those things does work.

The thread was discouraging to me, it was like watching 10 different people comment and none having any idea whatsoever!

Thanks

 

[WayneRyan]

Isaac,

Maybe you were using Redgate's SQL Prompt.

It's much easier to customize.

Wayne

 

[Isaac]

Isaac,

Maybe you were using Redgate's SQL Prompt.

It's much easier to customize.

Wayne

Mmm. That's a good point actually.. I may have been.