locked
Where Did Intellisense Go? RRS feed

  • Question

  • So,

    At home, in my own dev environmet, I have SQL Server 2008 R2 Express, with Advanced Services, which includes the latest R@ version of SSMS.  Additionally I have VS 2008 Pro.  And everything seems to work just fine.

    Now, I've started another job here, where we use SQL Server 2005 and also have SQL Server 2008 R2 for future plans, and we use VS 2010 Enterprise.

    So I go into SSMS and do a Simple:

    SELECT *
    FROM MyTable

    which works fine.  Once the MyTable is placed in the FROM list, I go back up to the SELECT * line and change it to:

    SELECT MyTable.

    Now when I type the . a list of columns should appear.  Nothing Happens.  I try hitting the Ctrl+J keyboard command to manually invoke it, but nothing ever occurs.  It is as if all Intellisense and code completion is completely destroyed.

    I thought at first perhaps the 2005 intellisense wasn't as advanced as the SSMS 2008 R2, so I tried that and the same exact problem.

    How do I get my SSMS to work regardless of whatever other "development" applications are installed.  VS 2010 shoudl have NOTHING to do with SSMS, they are separate programs, and yet i've begun to read that somehow VS 2010 can break SSMS intellisense. 

    Thanks

    Jaeden "Sifo Dyas" al'Raec Ruiner


    "Never Trust a computer. Your brain is smarter than any micro-chip."
    PS - Don't mark answers on other people's questions. There are such things as Vacations and Holidays which may reduce timely activity, and until the person asking the question can test your answer, it is not correct just because you think it is. Marking it correct for them often stops other people from even reading the question and possibly providing the real "correct" answer.
    Thursday, June 23, 2011 6:27 PM

Answers

  • 1. Intellisense only works with SQL Server 2008 and up, it doesn't work with SQL 2005 instance

    2. VS 2010 SP2 broke the intellisense. In order to get it back you need to install the latest cumulative update (CU7) for SQL Server 2008 R2.


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog
    • Marked as answer by JaedenRuiner Thursday, June 23, 2011 7:18 PM
    Thursday, June 23, 2011 7:07 PM

All replies

  • 1. Intellisense only works with SQL Server 2008 and up, it doesn't work with SQL 2005 instance

    2. VS 2010 SP2 broke the intellisense. In order to get it back you need to install the latest cumulative update (CU7) for SQL Server 2008 R2.


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog
    • Marked as answer by JaedenRuiner Thursday, June 23, 2011 7:18 PM
    Thursday, June 23, 2011 7:07 PM
  • Hi

    I tryed to Install SQL2008R2 SP1 but no intellisense. What to do?

     

    Gert

    Friday, October 7, 2011 2:02 PM
  • Can you please elaborate. Are you using SQL 2008 R2 SP1? What does SELECT @@VERSION show? Is intellisense enabled?
    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog
    Friday, October 7, 2011 2:06 PM
  • Hi Naomi.

    For my develop i run on Windows 7 And had VS2010, SQL 2008R2.

    4 days ago i install VS2010 SP1 and after that installation SQL Intellisense stop working in SQL Server. 

     

    Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64)   Sep 21 2011 22:45:45   Copyright (c) 1988-2008 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (VM)

     

    Thanks in advance

    Gert

     

     

    Saturday, October 8, 2011 6:37 AM
  • I red this in one other thread.

     

    After installing VS2010 SP1 I believe you need to install SQL2008R2 CU#7.

     

    Intend to try that, keep you posted.

     

    Gert

    Saturday, October 8, 2011 6:45 AM
  • I misread your original answer. Please install SP1 for SQL Server 2008 R2. The problem should be fixed with installing SP1. I though you had it installed.
    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog
    Sunday, October 9, 2011 2:54 AM