Post reply

Intelisense is not working !!! Even After trying everything mention on msdn website

  • May 16, 2013 at 6:44 am

    #272691

    Hi all Experts,

    I am trying this since a long time. My intellisense is not working with a specified Database. Intellisense i working for all other Database except one. I tried all the things that were told in this article http://blog.sqlauthority.com/2009/03/31/sql-server-2008-intellisense-does-not-work-enable-intellisense/ .

    Does any body know that how to enable the intellisense at Database Level.

  • May 16, 2013 at 6:51 am

    #1615746

    can you check the database compatibility of the database?

    i remember that SSMS disables Intellisense for SQL2005 (even though it's possible to enable it);

    maybe that functionality is based on checking the database compatibility level, and not the server version.

    SELECT

    cmptlevel

    FROM master.dbo.sysdatabases

    WHERE master.dbo.sysdatabases.name = DB_NAME()

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • May 16, 2013 at 10:12 pm

    #1616039

    Lowell (5/16/2013)

    can you check the database compatibility of the database?

    i remember that SSMS disables Intellisense for SQL2005 (even though it's possible to enable it);

    maybe that functionality is based on checking the database compatibility level, and not the server version.

    SELECT

    cmptlevel

    FROM master.dbo.sysdatabases

    WHERE master.dbo.sysdatabases.name = DB_NAME()

    The compatiblelevel value is 100. Which means its not the compitablility issue. 🙁

  • May 17, 2013 at 5:40 am

    #1616127

    90 also having no compitablility issue

  • May 17, 2013 at 6:50 am

    #1616146

    Sony Francis @EY (5/17/2013)

    90 also having no compitablility issue

    Then why Intellisense is not enabled only on ONE DB.:w00t:

  • May 17, 2013 at 6:53 am

    #1616150

    ok, it's possible if you newly created or attached a database, it might not be in the intellisense cache;

    usually it gets rebuilt on connecting to a server, but in SSMS do a Control + Shift + R (Or Edit>>Intellisense>>Refresh Local Cache) and see if that resolves the issue.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • May 17, 2013 at 11:21 am

    #1616279

    Or just turn off intelisense and get a tool that works.

    "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

  • May 17, 2013 at 11:26 am

    #1616286

    Grant Fritchey (5/17/2013)

    Or just turn off intelisense and get a tool that works.

    I have had to turn of SQL Prompt here at work as it sometimes fails due to memory issues. Other than that I do like it.

  • May 17, 2013 at 11:31 am

    #1616290

    Lynn Pettis (5/17/2013)

    Grant Fritchey (5/17/2013)

    Or just turn off intelisense and get a tool that works.

    I have had to turn of SQL Prompt here at work as it sometimes fails due to memory issues. Other than that I do like it.

    I have seen problems with VERY large numbers of objects.

    "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

  • May 17, 2013 at 11:37 am

    #1616295

    Grant Fritchey (5/17/2013)

    Lynn Pettis (5/17/2013)

    Grant Fritchey (5/17/2013)

    Or just turn off intelisense and get a tool that works.

    I have had to turn of SQL Prompt here at work as it sometimes fails due to memory issues. Other than that I do like it.

    I have seen problems with VERY large numbers of objects.

    Yep. That's why I wouldn't use it at a previous employer either. Sorry, but PeopleSoft databases have over 50,000+ tables alone.

  • May 19, 2013 at 9:10 pm

    #1616504

    Lowell (5/17/2013)

    ok, it's possible if you newly created or attached a database, it might not be in the intellisense cache;

    usually it gets rebuilt on connecting to a server, but in SSMS do a Control + Shift + R (Or Edit>>Intellisense>>Refresh Local Cache) and see if that resolves the issue.

    Still it doesn't work 🙁

  • May 19, 2013 at 9:12 pm

    #1616505

    Grant Fritchey (5/17/2013)

    Or just turn off intelisense and get a tool that works.

    I will have to pay for it :,(

Viewing 12 posts - 1 through 11 (of 11 total)

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