Not finding object in explorer if refresh is need

Provides intelligent code completion for SQL Server editors.

Not finding object in explorer if refresh is need

Postby » Fri Jun 20, 2014 3:41 pm

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
Posts: 11
Joined: Thu Mar 05, 2009 4:07 pm

Postby Aaron Law » Mon Jun 23, 2014 10:17 am


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.

Aaron Law
Posts: 561
Joined: Fri Jun 28, 2013 9:56 am
Location: Red Gate Software

Return to SQL Prompt

Who is online

Users browsing this forum: Bing [Bot] and 1 guest