How to disable intellisense in SQL 2008 permanently

Question

How to disable intellisense in SQL 2008 permanently

Jim-1146873

SSC Enthusiast

Points: 193
More actions
November 11, 2009 at 7:59 am

#213778

HI,
I want to disable intellisense in SQL server 2008 permanently for SQL client by script.
Note : I do not want disable it by using the IDE.
Ones disabled, only the Administrator should enable it. Client should not be given option to enalbe.
Kindly give your suggestions
Regards
Jim

Viewing 10 posts - 1 through 9 (of 9 total)

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

GSquared SSC Guru Points: 260824 More actions · Answer 1

If you deny select on the system objects to the accounts that aren't supposed to have intellisense, that should do it. It depends on the ability to select from the system schema views (sys.all_objects, sys.columns, and so on), if I'm not mistaken.

Try that, see how it goes.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Paul White SSC Guru Points: 150467 More actions · Answer 2

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Shell\Languages\Language Services\SQL

CodeSense = 0

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

saddamkhan74 Valued Member Points: 74 More actions · Answer 3

It appears that in Options->Text Editors->XAML, the Intellisense section is section is unavailable (grayed out). We open documents in Full XAML View, and don't use any third party enhancements.

rapid fire controller

xbox controller mod