September 25, 2012 at 3:50 am
from scouring the net, this seems to be a big problem, but i've yet to be able to cure it for myself.
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.
September 25, 2012 at 3:55 am
Run a repair on the installation, which should re-register the dll's etc and get intellisence working again.
September 26, 2012 at 3:45 am
thanks for the reply.
Ive just tried that, but it didn't work 🙁
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.
September 28, 2012 at 2:51 am
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.
September 28, 2012 at 3:32 am
Do you have SQLCMD mode open for new querries?
I solved the intellisense issue by unticking the box in Tools--Options--Query Execution
September 28, 2012 at 4:02 am
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.
September 28, 2012 at 8:57 am
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[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"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."
September 28, 2012 at 9:18 am
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.
October 3, 2012 at 2:35 am
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.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply