How can we improve SQL Prompt?

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.

3 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Tore BostrupTore Bostrup shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • David EedleDavid Eedle commented  ·   ·  Flag as inappropriate

        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.

      Feedback and Knowledge Base