Refresh Suggestions, delay?
The SQLPrompt Intellisense doesn't seem to update when I use the "Refresh Suggestions" option (Ctrl+Shift+D).
For example, I just created a new stored procedure. I clicked "Refresh Suggestions", but the new stored proc is still not yet available in the intellisense suggestions. I'm also using (Ctrl+Shift+R) to refresh SSMS's intellisense.
It's now been about 10 minutes since the proc was deployed and I've Refreshed Suggestions as well as Intellisense Cache probably 10 times at this point. Am I missing something? Is this normal? Is this a known issue? Or is it just me?
I've been having this problem for at least a year and I've just dealt with it as I can quickly get around it. But I'm finally asking, because I'm going to lose it if there's a quick an easy answer.
The server I'm currently working on has 25 databases.
And I have all of these SQL prompt settings checked:
> Load suggestions for linked servers
> Load suggestions for synonyms
>>> Load referenced databases