Intellisence not working via SSMS2k8 on SQL 2k8 SP1

  • Hi All

    Was just wondering if anyone would know why intellisence would stop working?

    I have google'd many sites detailing check tools-->options-->Text Editor-->Transact-SQL-->General/IntelliSence and all is fine there.

    IntelliSence is enabled.

    I have done CTRL+SHIFT+R to do a cache refresh but IntelliSence is still not working.

    Any help would be great.

    Thanks

    Anthony

  • Is Query --> IntelliSense Enabled option selected? If yes, then you may try "Repairing" SQL Server in the "Add/Remove" applet.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • Define 'not working'

    No intellisense at all? Not showing correct objects?

    Absolutely sure it's not a 2005 instance you're connected to?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Hi Adiga

    Query --> IntelliSence Enabled is checked, I shall try a repair via Add Remove Programs shortly.

    Hi Gail

    In terms of the 'not working' I am not seeing the popup box with all the different objects etc which you would expect to see which indicates its not working at all.

    IntelliSence works on my notebook, but is not working on my desktop, both using SSMS2k8 and connected to the same server and database.

    Thanks

    Ant

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply