How do i enable auto complete at MS-SQL 2012 - actually auto select as you type

Question

I don't know why it is not default enabled but let me give example

for example my table name is mytable

after i typed my it should auto select it since there is no other table that starts with my

but not doing it

Right now it is filling results via intellisense as you type But it is not auto selecting When you hit ctrl + alt + space at the same time, it starts auto selecting as you type for only that query I want this feature to be permanent Here image of both scenario no auto select auto select enabled (i want this permanent)

---

Browser based Pokemon Style MMORPG Game Developer Used asp.net 4.0 routing at it's Monsters

Answer 1

if i hit ctrl alt space bar it start working but i want it permanent

---

Browser based Pokemon Style MMORPG Game Developer Used asp.net 4.0 routing at it's Monsters

Answer 2

Have you enabled intellisense?

have a look at this link too

http://blog.sqlauthority.com/2009/03/31/sql-server-2008-intellisense-does-not-work-enable-intellisense/

---

Satheesh

Answer 3

Have you enabled intellisense?

have a look at this link too

http://blog.sqlauthority.com/2009/03/31/sql-server-2008-intellisense-does-not-work-enable-intellisense/

---

Satheesh

yes i have already enabled

if i press ctrl alt space it starts auto selecting the intelligience

but i want it permanent

---

Browser based Pokemon Style MMORPG Game Developer Used asp.net 4.0 routing at it's Monsters

Answer 4

>if i press ctrl alt space it starts auto selecting the intelligience

You don't have to press anything is IntelliSense is enabled.

What is @@version?

You may have to reinstall SSMS.

---

Kalman Toth Database & OLAP Architect
Paperback / Kindle: Windows Azure SQL Database Programming & Design

Answer 5

You can try refreshing local cache

here are the steps to refresh local cache
Press CTRL+SHIFT+R 

Or
Go to Edit >> IntelliSense >> Refresh Local Cache

---

Satheesh

Answer 6

Wow still no answer for this question

here what i mean

Right now it is filling results via intellisense as you type But it is not auto selecting When you hit ctrl + alt + space at the same time, it starts auto selecting as you type for only that query I want this feature to be permanent Here image of both scenario no auto select auto select enabled (i want this permanent)

---

Browser based Pokemon Style MMORPG Game Developer Used asp.net 4.0 routing at it's Monsters

Answer 7

did you try refreshing the Intellisense Cache as I mentioned in earlier post. That had worked for me

---

Satheesh

Answer 8

did you try refreshing the Intellisense Cache as I mentioned in earlier post. That had worked for me

---

Satheesh

just wow man. are you reading what i am writing ? it is not auto selecting

the problem is not auto filling - it fills auto as supposed to be

please check the images

and yes i tried it does not fix the problem

---

Browser based Pokemon Style MMORPG Game Developer Used asp.net 4.0 routing at it's Monsters

Answer 9

Okay,  It doesn't happen to me either and  I think that's the way it works, but I am not sure.

---

Satheesh

Answer 10

Okay,  It doesn't happen to me either and  I think that's the way it works, but I am not sure.

---

Satheesh

if you hit ctrl + alt + space

it does for that query

but for only that one

---

Browser based Pokemon Style MMORPG Game Developer Used asp.net 4.0 routing at it's Monsters

Answer 11

Yes, I think its a problem with the intellisense as it doesn't persist the "Toggle Completion Mode" setting

So its a designed behavior or a bug :-) 

and I found a connect item on the same issue 

http://connect.microsoft.com/SQLServer/feedback/details/686087/intellisense-completion-mode-does-not-persist

---

Satheesh

Answer 12

ths problem still does exists

installed on 3 different machines

installed iso is : SQLServer2012SP1-FullSlipstream-ENU-x64

---

Browser based Pokemon Style MMORPG Game Developer Used asp.net 4.0 routing at it's Monsters

Answer 13

I think you didn't look at the connect item. It is a active bug yet to be closed by MS.

http://connect.microsoft.com/SQLServer/feedback/details/686087/intellisense-completion-mode-does-not-persist

so at best what you can do is go to the connect item and vote for it so that priority for this bug fix would increase 

---

Satheesh

Answer 14

I think you didn't look at the connect item. It is a active bug yet to be closed by MS.

http://connect.microsoft.com/SQLServer/feedback/details/686087/intellisense-completion-mode-does-not-persist

so at best what you can do is go to the connect item and vote for it so that priority for this bug fix would increase 

---

Satheesh

yes i saw it is closed but it does exists!

so i will keep bumping here

---

Browser based Pokemon Style MMORPG Game Developer Used asp.net 4.0 routing at it's Monsters

Answer 15

this bug is still active one. It is NOT closed.

---

Satheesh

Answer 16

i just recently installed windows server 2012

installed there new sql server installation

it is set all usa expect keyboard input is Turkish

and this bug also exists at this new machine installation everything

---

Browser based Pokemon Style MMORPG Game Developer Used asp.net 4.0 routing at it's Monsters