As I click open on a query in SQL History it gets displayed in a new tab. However this tab has no active connection. To be able to run the query I have to connect the tab manually to the database.
For me it would be much easier if opening the query from History would also open a connection to the database the query ran the last time.
If there are specific reasons why this was not implemented it would still be nice, if there were an option available to automatically connect to the server.
We think this might be covered in the options.
There is an option to automatically reconnect restored queries in SQL Prompt -> Options -> Queries / History. There's also some help with it that reads "If you're using SQL Server authentication, you need to select Remember password on the Connect to Server dialog box. If you don't, SQL Prompt won't be able to reconnect your queries automatically."
Let me know if this doesn't help. What else are you looking for here?