Irritating Bug/feature?

  • This is irritating the living daylights out of me.

    Create a database.

    Create some tables

    Close SSMS

    Open SSMS

    Create Stored Proc on some tables

    Create New Table

    Create New Proc for the new table.

    SSMS is aware of the new table since you can highlight it and press alt F1 to get the def. It is also in the list of tables.

    Yet Every object from that table, including the table is underlined in squigly red lines, and is not available when trying to use the tab function. Also If I hover the cursor over the "error text" It shows a tool tip text that the object is not available.

    I have to close and open SSMS in order for it to recognize the new objects :crazy:

    Guess this bug is good for Prompt sales, esp with the new vamped up version?

    I must admit, I have not tried the new prompt yet. My company is not eager to spend money...

    Any one know how to fix this error? Or is only me getting this? Perhaps a config problem on my pc?

  • [control] + [shift] + [r]

    This will refresh the intellisense.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • Sean Lange (2/17/2011)


    [control] + [shift] + [r]

    This will refresh the intellisense.

    Is this the point where I should facepalm my self and shout Doh! in my best Homer Simpson Impersonation?

    DOH!

    Since about a year ago when we moved development to 2008, I've been restarting SSMS when working on complex procs.

    Thanks a mil!!!:cool:

  • LOL no problem. I too hated that until I figured out how to get it to refresh. It really makes sense that SSMS would not be checking everytime some sql is run to decided if it needs to refresh, or worse yet did it every time. Glad to save you some headaches. :w00t:

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • It actually does make sense...

    20/20 Hindsight vision 🙂

    If you create a custom user control in c#, you need to do a build of the app for the new methods to be available for intelisense.

  • Now the real problem with SSMS Intellisense:

    How do you stop it from auto-completing when you press period or space? This has been the single most frustrating aspect of SSMS for me. Pressing escape after every single table/schema/object/column name so it doesn't replace it with the wrong one is AWFUL.

  • Derrick Smith (2/17/2011)


    Now the real problem with SSMS Intellisense:

    How do you stop it from auto-completing when you press period or space?

    Turn it off and get a replacement that actually works (unfortunately not free)

    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
  • GilaMonster (2/17/2011)


    Derrick Smith (2/17/2011)


    Now the real problem with SSMS Intellisense:

    How do you stop it from auto-completing when you press period or space?

    Turn it off and get a replacement that actually works (unfortunately not free)

    Yep..unfortunately the people in my department who approve such purchases are heavy VS users..and the VS intellisense is actually quite good. They assume SSMS is the same.

  • Intelli-busy body! It is as bad as the legendary (and loathed) paperclip in office.

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

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