SQL Server 2008 Intellisense update/refresh on schema changes RRS feed

  • Question

  • Hello,


    Using SSMS since RTM release and it seems like a great upgrade.  The intellisense is a great new feature but I am having a bit of trouble with it.


    If I make any change (new table, column name change, new udf, sp, etc) while SSMS is open those changes are not reflected in current or even new Query editor windows in that instance of SSMS.   I can get the new details by closing out SSMS and launching again. It seems that the intellisense data is built and cached at some point and I cannot find any method for refreshing it.  


    If I am working in SSMS with open query editor windows then make a change - what is my best way to get that to into the intellisense cache?  Is closing out SSMS the only way - or is there a less drastic way? 


    I have tried combinations of the following and none seem to work:


    Opening new query windows

    Refreshing the object explorer at different levels (table, database, server)

    Enabling/Disabling intellisense from the query window toolbar

    Enabling/Disabling intellisense from the Tools->Options menu


    Please let me know if there is a workaround for this.






    Tuesday, August 12, 2008 11:55 PM


  • Actually this is because Objects are cached. You can refresh cache using

    Edit -> Intellisense -> Refresh Local Cache (CTRL+Shift+R)


    Hope this help.

    Wednesday, August 13, 2008 3:41 AM
  • Devpal is correct. The refresh should fix your issue.


    Wednesday, August 13, 2008 6:07 PM

All replies