SQL Prompt tries to retrieve objects from other databases
After upgrading to SQL Prompt 6 (6.1), I notice reduced performance and I occasionally get "SQL Prompt cannot retrieve objects from <some database name>. (etc)", which reference a database that I do not use or am ever likely to use and IIRC have never used. It seems SQL Prompt is trying to cache objects for all databases on the connected server. That would be overkill, and only serves to slow it down and cause errors such as the one mentioned.
Tore Bostrup
shared this idea
This was likely due to the synonym support added in 6 which will try to offer suggestions by loading databases that the synonyms are referencing. In the latest build of Prompt this is optional (under Suggestions→Connections) and off by default.
-
David Eedle
commented
I've had exactly the same experience since upgrading a couple of days ago, it's extraordinarily annoying, and definitely only occurring since the update. It's trying to query databases on the same server, but for which the login I am using does not have permission.