Comments
5 comments
-
Official commentHi Axium7,
Thank you for reaching out on the Redgate forums regarding your SQL Search inquiry.
Unfortunately, SQL Search does not store any default settings that can be recalled.
Drop-down selection is recalled for the active SSMS session, and this data is dropped when that session closes.
The displayed information in these drop-downs depends on a connection to your database instances so they can be populated. This is generated when a connection is made and isn't stored outside the active session.
You can post this on our UserVoice forum as a feature request if this is something you'd like to see:
-
About half the time I cannot get a list of my 3 databases, causing the search not to work. I have the latest version of SSMS installed.
-
Sorry to hear that is happening, are you able to confirm what version of SSMS you are using SQL Search in?
If you are using it in SSMS21, can you confirm if the same issues with refreshing databases are occurring in SSMS18-20 also?
We have recently implemented preview support for SSMS21 and may have some bugs like this occurring.
If you are using SSMS18-20, can you locate the most recent log file and provide a copy of it for investigation.
You can access it in the Help > Logging > Locate log files menu option.
You can provide logs to this secure file link, it will be valid for 14 days:
-
I send you some Logs Jon. I am using SSMS 20.2. This morning the connection is working but it wasn't working on Monday.
-
Another issue:
Add comment
Please sign in to leave a comment.
Hello RedGate,
When I open SSMS I would like the SQL Search Tab to be opened and pinned, and to have the prior session parameters be preserved as depicted in the screenshot.
Currently every time I open SSMS I have to Connect to the local Server and then set up all these parameters. I would like to automate the Startup process to eliminate these repeated steps.
Thank you for your advice.