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


Add to briefcase

Intellisense not working Expand / Collapse
Author
Message
Posted Wednesday, February 26, 2014 9:36 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 12:30 PM
Points: 310, Visits: 586
I upgrade SQL 2008 express to SQL 2012 standard but Intellisense did not work.
From tools, Text editor, transact-SQL, Intellisense, I checked enable.
How to make Intellisense work?
Post #1545467
Posted Wednesday, February 26, 2014 9:58 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 11:49 AM
Points: 288, Visits: 1,166
Yeah.....It's buggy sometimes. Did you tried refreshing your IntelliSense local cache? You can do that from Edit->Intellisense->Refresh local cache.
Also, patch your SSMS to the latest build. If you are not satisfied with Native intellisense, you could try adding free tools like ApexSQL SQLComplete plugin to your SSMS.

Disclaimer: I don't work for ApexSQL...I just love that free tool which they are offering.
Post #1545476
Posted Wednesday, February 26, 2014 10:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 18, 2014 7:56 AM
Points: 2, Visits: 71
Hi!
You can try this IntelliSense


______________________________
Sincerely,
SQL Refactor Studio Team
http://sqlrefactorstudio.com/
Post #1545495
Posted Wednesday, February 26, 2014 1:18 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 12:30 PM
Points: 310, Visits: 586
I installed ApexSQL, it works great. Thanks.
Post #1545561
Posted Thursday, February 27, 2014 6:28 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:27 PM
Points: 13,776, Visits: 28,178
I've never found Intellisense to work adequately. Another tool to try is SQL Prompt from Red Gate Software.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1545835
Posted Thursday, February 27, 2014 6:47 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 12:30 PM
Points: 310, Visits: 586
SQL prompt costs $369
Post #1545854
Posted Thursday, February 27, 2014 7:12 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:22 PM
Points: 2,580, Visits: 3,876
Intellisense in SQL Server stopped working for me when I isntalled Visual Studio 2010.

David Haney has a write-up here about it.

http://www.haneycodes.net/visual-studio-2012-intellisense-not-working-solved/

I just got used to not having it. It sometimes seems to get in the way.

Intellisense still works in VS 2010 but not SQL Server.

Tom
Post #1545867
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse