SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On



How to disable intellisense in SQL 2008 permanently Expand / Collapse
Author
Message
Posted Wednesday, November 11, 2009 7:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, February 13, 2010 11:29 PM
Points: 9, Visits: 22
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
Post #817174
Posted Wednesday, November 11, 2009 8:02 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, March 19, 2010 2:45 PM
Points: 8,681, Visits: 4,953
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.


- GSquared

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #817180
Posted Monday, November 16, 2009 3:14 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:56 AM
Points: 4,714, Visits: 3,100
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Shell\Languages\Language Services\SQL

CodeSense = 0
Post #819273
Posted Friday, November 27, 2009 5:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 27, 2009 5:27 AM
Points: 2, Visits: 2
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
Post #825568
Posted Tuesday, December 01, 2009 6:05 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, March 15, 2010 5:23 PM
Points: 399, Visits: 454
Check this article, this might help you

http://sql-articles.com/articles/dba/intellisence-sql-server-2008


Regards..Vidhya Sagar
SQL-Articles
Post #826586
« Prev Topic | Next Topic »


Permissions Expand / Collapse