Need to be able to search multiple databases

[gbritton1]

I have a connection to a server with the default master database. AS in SSMS, I want to use SQL Search to search across multiple databases and/or be able to select which database(s) to search

[aisbergde]

This is a very important feature. The current implementation is completely unusable because either only Master is searched (where of course nothing is found), or you would have to create a separate connection for each database to search it.

In order to search in a specific database

• all other connections must be closed first
• only the connection to the database you want to search must be open
• you have to reindex
• only then results will be found

I know SQL Search from SSMS. There it works very well. But now I have a computer without admin rights and cannot install SSMS extensions. So I thought: No problem, I will use ADS. And I use a redgate product. But the current implementation of SQL Search for ADS is unfortunately not usable for practical use if you want to work with multiple databases.

[aisbergde]

I just tried it a second time. It does not work as described above. At the first attempt I was offered to search in the other "Connection". Now it searches again only in Master and nothing is found. Even a restart of ADS does not help. So it seems to have been a coincidence that content was found at all once.