cannot get sql intellisense working after vs2010 update

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » cannot get sql intellisense working after...

cannot get sql intellisense working after vs2010 update

Rate Topic

Display Mode

Topic Options

Author

Message

davidandrews13

Posted Tuesday, September 25, 2012 3:50 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 10:15 AM
Points: 463, Visits: 2,714

from scouring the net, this seems to be a big problem, but i've yet to be able to cure it for myself.

http://connect.microsoft.com/SQLServer/feedback/details/650569/ssms-2008-r2-is-losing-intellisense-after-installing-visual-studio-2010-sp1

i've attempted to run the Cumulative Update 13 (http://support.microsoft.com/kb/2679366) for SQL Server 2008 R2, but when running the Update, and getting to the 'Select Features' part, it states that there are no SQL Server instances that can be updated.
I@m presuming this is because i am fully updated.

This not only stops me from being able to use intellisense, but the whole of SSMS hangs when using keyboard shortcuts such as 'ctrl+]' to step between syntax pairs.

has anyone else experienced this and managed to cure it some other way?
i've definitely activated intellisense within SSMS.

Post #1363890

anthony.green

Posted Tuesday, September 25, 2012 3:55 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 2:40 AM
Points: 5,075, Visits: 4,833

Run a repair on the installation, which should re-register the dll's etc and get intellisence working again.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1363892

davidandrews13

Posted Wednesday, September 26, 2012 3:45 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 10:15 AM
Points: 463, Visits: 2,714

thanks for the reply.
Ive just tried that, but it didn't work Sad

i attempted a Repair on:

microsoft sql server 2008 r2 management objects
microsoft sql server 2008 r2 management objects (x64)
Microsoft SQL SErver 2008 R2 Transact-SQL Language Service

no luck, though. Intellisense still doesn't work.

Post #1364532

davidandrews13

Posted Friday, September 28, 2012 2:51 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 10:15 AM
Points: 463, Visits: 2,714

just in case it jogs anyone elses memory, i've just installed Service Pack 2 (32 bit version, although i have 64bit windows 7) for Microsoft® SQL Server® 2008 R2 from http://www.microsoft.com/en-us/download/details.aspx?id=30437.

i've restarted my computer, refreshed ssms intellisense (ctrl+shift+R), turned intellisense off/on via the button at the top of SSMS and still no luck.

Post #1365691

xanthos

Posted Friday, September 28, 2012 3:32 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:23 AM
Points: 267, Visits: 624

Do you have SQLCMD mode open for new querries?

I solved the intellisense issue by unticking the box in Tools--Options--Query Execution

Post #1365716

davidandrews13

Posted Friday, September 28, 2012 4:02 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 10:15 AM
Points: 463, Visits: 2,714

xanthos (9/28/2012)

Do you have SQLCMD mode open for new querries?

I solved the intellisense issue by unticking the box in Tools--Options--Query Execution

just had a quick check and that box is unticked for me. I ticked it and saved, then unticked it again, just in case there was a conflict, but that didn't resolve it.

Post #1365736

jcrawf02

Posted Friday, September 28, 2012 8:57 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:46 PM
Points: 2,561, Visits: 18,910

Kinda rough suggestion, I realize it, but basically Why Bother?

Install SSMS Tools Pack (free) or buy RedGate SQL Prompt.

Works lots better than Intellinonsense.

---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Post #1365927

davidandrews13

Posted Friday, September 28, 2012 9:18 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 10:15 AM
Points: 463, Visits: 2,714

jcrawf02 (9/28/2012)

Kinda rough suggestion, I realize it, but basically Why Bother?

Install SSMS Tools Pack (free) or buy RedGate SQL Prompt.

Works lots better than Intellinonsense.

thanks, i've downloaded it and can see the toolbar option for 'SSMS Tools' but can't see how to turn on its intellisense option. currently, intellisense isn't working with SSMS Tools.

Post #1365951

davidandrews13

Posted Wednesday, October 03, 2012 2:35 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 10:15 AM
Points: 463, Visits: 2,714

i've given up on trying to get the in-built intellisense working again and found a great free third party tool: http://www.atlantisinteractive.co.uk/products/sqleverywhere/default.aspx

it even suggests the columns to join on when dealing with multiple tables.

Post #1367464

« Prev Topic | Next Topic »

Permissions