question

Mrs_Fatherjack avatar image
Mrs_Fatherjack asked

SQL Search

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?
searchredgate
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Mrs_Fatherjack avatar image
Mrs_Fatherjack answered
I have just realised that the server I want to connect to is SQL 2000 and SQL Search does not work with SQL 2000 :(
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Mark avatar image
Mark answered
Yes, I ran onto that issue as well. First, you have to connect to the server and open a new query window. *Then* open SQL Search and, there you have it.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

dvroman avatar image
dvroman answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered
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.
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I tried this but the SQL Search option only becomes active when I connect to one of the servers, this was the server I originally connected to. How do I close SQL Server when I don't have any options to do anything with it as it's completely greyed out?
0 Likes 0 ·
- close SQL Search window
- connect to the server you want to search so that it is in the Object Explorer
- re-open SQLSearch
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.