How to disable intellisense in SQL 2008 permanently

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Strategies » How to disable intellisense in SQL 2008...

How to disable intellisense in SQL 2008 permanently

Rate Topic

Display Mode

Topic Options

Author

Message

Jim-1146873

Posted Wednesday, November 11, 2009 7:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 24, 2010 12:38 AM
Points: 9, Visits: 24

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

GSquared

Posted Wednesday, November 11, 2009 8:02 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

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

Post #817180

Paul White

Posted Monday, November 16, 2009 3:14 AM

SSChampion

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 10:33 AM
Points: 10,989, Visits: 10,529

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

CodeSense = 0

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #819273

saddamkhan74

Posted Friday, November 27, 2009 5:32 AM

Forum 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

vidhya sagar

Posted Tuesday, December 01, 2009 6:05 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 2:45 AM
Points: 416, Visits: 521

Check this article, this might help you

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

Regards..Vidhya Sagar
SQL-Articles

Post #826586

battula.praveen

Posted Monday, March 29, 2010 2:00 AM

Grasshopper

Group: General Forum Members
Last Login: Saturday, June 12, 2010 9:31 AM
Points: 12, Visits: 14

Here is the solution you are looking for you,
http://sqlserver.ro/blogs/cristians_blog/archive/2007/11/20/turning-off-intellisense-in-sql-server-2008-ctp5.aspx

Post #891638

Paul White

Posted Monday, March 29, 2010 2:21 AM

SSChampion

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 10:33 AM
Points: 10,989, Visits: 10,529

battula.praveen (3/29/2010)

Here is the solution you are looking for you[/url]

I posted the same thing three posts before you.

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #891646

battula.praveen

Posted Monday, March 29, 2010 2:32 AM

Grasshopper

Group: General Forum Members
Last Login: Saturday, June 12, 2010 9:31 AM
Points: 12, Visits: 14

Sorry, didn't look at your second post. That was my mistake. Please don't consider it.

thanks

Post #891652

tony.price.uk

Posted Thursday, November 29, 2012 10:23 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, November 29, 2012 10:22 PM
Points: 1, Visits: 0

From SSMS
Tools>Options>Text Editor>Transact SQL>Intellisense> Enable/Disable

Post #1391012

Paul White

Posted Thursday, November 29, 2012 11:00 PM

SSChampion

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 10:33 AM
Points: 10,989, Visits: 10,529

tony.price.uk (11/29/2012)

From SSMS
Tools>Options>Text Editor>Transact SQL>Intellisense> Enable/Disable

This works, of course, but it doesn't address the requirement in the first post.

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #1391018

« Prev Topic | Next Topic »

Permissions