Post reply

sql server 2008 r2 sp1 intellisense not working

  • January 23, 2014 at 4:18 am

    #281454

    Hi Guys,

    can you give me solutions to solve intellisense problem in sql server 2008 r2 sp1

    version details:

    Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Developer Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1)

    i re-registered "TextMgrP.dll" but not solve intellisense problem.

    --chalam

  • January 23, 2014 at 4:38 am

    #1682708

    Has it ever worked for you? If so, what has changed?

  • January 23, 2014 at 4:48 am

    #1682712

    Check the compatibility level of the database you're querying against. If it's an older version, that can prevent Intellisense from working. Other than that, ensure that it's enabled and understand that it's extremely limited.

    Intellisense never worked well for me. I always use Red Gate SQL Prompt[/url] instead (and yeah, I work for Red Gate now, but I've been using that tool for years & years before I went to work for the company).

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • January 23, 2014 at 6:06 am

    #1682739

    Do you have any versions of Visual Studio/TFS installed as well? One of our developers' Intellisense stopped working which was caused by an SP install of VS 20101 if I remember rightly, and a hotfix was supplied by MS (via Windows Update) to rectify this.

  • January 23, 2014 at 10:38 pm

    #1683006

    Hi Valued Member,

    i have install vs sp1 in my system,for rectify this problem which software(hot fix) i have to install .

    Below are sql server version details which i use in my system.

    Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Developer Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1)

    --chalam

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

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