Post reply

Intellisense Question

  • March 4, 2009 at 11:07 am

    #200475

    Ok, I admit it. I LOVE Intellisense, code completion or whatever they might like to call it in your favorite IDE. I am so glad SQL 2008 added this.

    I have noticed something odd, though.

    I generated a script to create a new stored procedure. Intellisense was working quite well for me.

    I realized that I needed to rename a field in one of my tables, so I did so from the same instance of the IDE. Intellisense would not recognize the new field name in this table.

    I continued anyway. While I was editing the script, I realized that I would need a new view to work with in my script. So, I paused my script editing and from the same copy of the IDE, I created the new view.

    I went back to editing the script and the Intellisense would not recognize the new view. I disabled then re-enabled Intellisense - no good. I saved the file, closed it and re-opened the file - still no good. I closed it again, then did a right-click, Refresh on the database. Re-opened the file - still no good.

    I closed the file, then disconnected from my database and reconnected. Re-opened the file - STILL NO GOOD.

    It was not until I closed SMS and re-opened it from scratch that Intellisense recognized the changes I had made.

    Anyone have any clues? Did I do something wrong?

    Jim

  • March 4, 2009 at 11:18 am

    #953449

    The cache is not refreshed real-time. To force a refresh, Edit -Intellisense -Refresh Local Cache (Ctrl-Shift-R)

    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

  • March 5, 2009 at 11:59 am

    #954272

    You think IntelliSense is good? Try RedGate SQL Prompt 😛

    command to refresh cache in SQL Prompt is CTRL-SHIFT-D

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

  • March 14, 2009 at 6:41 am

    #959686

    I can see where there is room for improvement in both; SQL Server doesn't capitalize as does Red Gate, and SQL Server doesn't have the nice DDL boxes that come up on the one hand. On the other, those same boxes drive me crazy sometimes. 😀

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

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