Changing the Server to Search

dbbishop

I've got several tabs open in SSMS with connections to a couple of servers. I want to do a search on one of the servers but the dropdown is only listing one server. How do I change the server that SQL Search will search? It is just a dropdown and I cannot enter anything in it.

Jon_Kirkwood

Hi @dbbishop

 Thank you for reaching out on the Redgate forums regarding your SQL Search question.

SQL Search uses SSMS's connections to servers to conduct searching, this is limited to the session in which SQL Search is running.

If you have multiple instances of SSMS open with different connections, SQL Search will only be able to utilize the active connection in that instance.

 

To get more servers in the drop-down box, you will need to connect to them in SSMS prior to searching.

 

dbbishop

I had 3 tabs open each with a connection to a different server but only had one of the servers available in the dropdown.
I ultimately 'fixed' it by exciting SSMS and loading it again and connecting only to the server I wanted to search.