Not finding object in explorer if refresh is need

eklein@ahd.comeklein@ahd.com Posts: 17 Bronze 2
edited June 23, 2014 6:17AM in SQL Prompt
Select object in explorer is great, but it the object has just been created and is not appearing in the list because a "refresh" is needed, then it is not found. Consider forcing a refresh, if not found occurs. The code knows the object exists, because pop-up window comes up with it's definition
· Share on Twitter

Comments

  • Aaron LAaron L Posts: 596 New member
    Hi,

    This sounds like a reasonable suggestion, however it's not quite as simple as us "knowing" that the object exists as Prompt also has a local cache which could be out of date. I guess the problem could come if the database that needs a refresh has a connection issue or is just over a slow connection and causes SSMS to lock up.

    We've just received a UserVoice request in a similar area related to clearing out filters if the object you are trying to select is currently filtered out. It would be great if you could add this suggestion to UserVoice (either as a new idea or comment to the existing one) as we use it to prioritise what we'll work on next.

    Thanks,
    Aaron.
    · Share on Twitter
Sign In or Register to comment.