Auto Connect DB for Opened Tabs After Restart or Hibernate

sulemankhalidsulemankhalid Posts: 5 Bronze 1
edited July 27, 2020 7:19AM in SQL Prompt
I am using SQL Management Studio 18 and SQL Prompt 10.3

If I restart or hibernate PC then opened tabs in SQL management studio comes back but not connected to the DB, also when reconnecting these manually to DB it reset the selected database to tempdb in the dropdown of available databases.

Is it possible for tabs to auto-connect to the database and also keep previously selected database name in the dropdown?
Tagged:
· Share on Twitter

Answers

  • DanCDanC Posts: 637 Gold 5
    Hi @sulemankhalid

    Sorry to hear you're experiencing this issue!

    Could I ask, do you have ApexSQL installed onto your SQL Server as this has been known to cause some conflicts and create bugs within SQL Prompt. 

    Kind regards

    Dan Calver | Redgate Software
    Have you visited our     Help Center?

    · Share on Twitter
  • sulemankhalidsulemankhalid Posts: 5 Bronze 1
    ApexSQL is not installed.
    I have upgraded SSMS to 18.6 and also updated SQL Prompt to the latest version.

    I have noticed that this issue occurs only when the PC comes back from hibernate.
    · Share on Twitter
  • DanCDanC Posts: 637 Gold 5
    edited July 29, 2020 10:55AM
    Hi @sulemankhalid

    So the team have recognized this as a bug and unfortunately with their current workload, they're unable to prioritize looking into this to fix. 

    I apologize for any inconvenience caused by this!

    Kind regards

    Dan Calver | Redgate Software
    Have you visited our     Help Center?

    · Share on Twitter
Sign In or Register to comment.