Post reply

Intellisense Not working..

  • February 23, 2012 at 2:13 pm

    #257269

    Hi guys

    Can you help me to solve this Intellisense Issue..?

    Have SQL server 2008 R2 SP1 but still Intellisense not working?

    any idea?

    Thanks

  • February 23, 2012 at 3:09 pm

    #1451122

    Check the database compatibility level. Can be found in the GUI by right clicking on the database > properties.

  • February 23, 2012 at 3:20 pm

    #1451128

    its SQl Server 2008 (100)

  • February 23, 2012 at 3:40 pm

    #1451137

    Did you check Microsoft's document on troubleshooting Intellisense?... http://msdn.microsoft.com/en-us/library/ms173434.aspx

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • February 23, 2012 at 9:55 pm

    #1451171

    Try re-registering TextMgrP.dll.

  • February 24, 2012 at 2:25 am

    #1451243

    sqlzealot-81 (2/23/2012)

    Try re-registering TextMgrP.dll.

    This has helped me in the past: Full command line - regsvr32 "C:\Program Files (x86)\Common Files\microsoft shared\MSEnv\TextMgrP.dll"

    Also, If you have a 3rd party IntelliSense installed (such as redgates IntelliSense) but the trial / license has run out then the microsoft IntelliSense will not take back over - you will need to uninstall the 3rd party app first.

    [font="Times New Roman"]There's no kill switch on awesome![/font]

  • February 24, 2012 at 4:57 am

    #1451317

    Loundy (2/24/2012)

    sqlzealot-81 (2/23/2012)

    Try re-registering TextMgrP.dll.

    This has helped me in the past: Full command line - regsvr32 "C:\Program Files (x86)\Common Files\microsoft shared\MSEnv\TextMgrP.dll"

    Also, If you have a 3rd party IntelliSense installed (such as redgates IntelliSense) but the trial / license has run out then the microsoft IntelliSense will not take back over - you will need to uninstall the 3rd party app first.

    Not true. You can run both at the same time. You'll get weird behavior, but you can. If you've switched off SSMS Intellisense while trying out a third party product, you just have to switch it back on.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • February 24, 2012 at 5:39 am

    #1451335

    Grant Fritchey (2/24/2012)

    Loundy (2/24/2012)

    sqlzealot-81 (2/23/2012)

    Try re-registering TextMgrP.dll.

    This has helped me in the past: Full command line - regsvr32 "C:\Program Files (x86)\Common Files\microsoft shared\MSEnv\TextMgrP.dll"

    Also, If you have a 3rd party IntelliSense installed (such as redgates IntelliSense) but the trial / license has run out then the microsoft IntelliSense will not take back over - you will need to uninstall the 3rd party app first.

    Not true. You can run both at the same time. You'll get weird behavior, but you can. If you've switched off SSMS Intellisense while trying out a third party product, you just have to switch it back on.

    ah ok - cheers for the correction 🙂

    [font="Times New Roman"]There's no kill switch on awesome![/font]

  • February 24, 2012 at 7:38 am

    #1451397

    Ya i found this file .. so can you explain me whats mean of re-register please?

Viewing 9 posts - 1 through 8 (of 8 total)

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