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.