Changing the Server to Search

dbbishopdbbishop Posts: 16 Bronze 2
in SQL Search
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.
Tagged:
· Share on Twitter

Answers

  • Jon_KirkwoodJon_Kirkwood Posts: 441 Gold 1

    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.

     

    Jon Kirkwood | Technical Support Engineer | Redgate Software
    · Share on Twitter
  • dbbishopdbbishop Posts: 16 Bronze 2
    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. 
    · Share on Twitter
  • SimonElmsSimonElms Posts: 1 New member
    It seems to pick up the servers from Object Explorer, rather than from the query windows you have open. 

    I had a couple of localdb instances open in Object Explorer but the only query windows I had open were to the QA and prod servers.  The server dropdown list in SQL Search only included the servers that were open in Object Explorer (the localdb instances), not the servers I was connected to via the query windows.
    · Share on Twitter
Sign In or Register to comment.