I wonder if anyone can advise me, I'm probably missing something really obvious, but . . . I'm using Redgates SQL Search but it will only let me use it on one server, how can I change the server it's pointing at?
I ran into that too. My answer is to exit from the search tool, connect to the servers I want to search making sure that I have a window open for each one and re-open the tool.
Most of the time this works. Sometimes I don't get all of the servers so I try again. Eventually it works.
The drop-down at the far right of the SQL Search window 'should' list all servers that you have open in the Object Explorer(F8) so if you dont see a server listed there then you need to close SQL Search, connect to the server you want to search in the Object Explorer panel and then re-open SQL Search. You should see all servers that are in Object Explorer now listed in the server drop down list in SQL Search.