Multi-Database Issues

A free Management Studio add-in to search for SQL in your databases

Multi-Database Issues

Postby csuire » Fri May 23, 2014 9:57 pm

SQLSearch2 sometimes detects the current database.
Othertimes it defaults to all databases.

For servers with LOTS of database, it can be annoying when it defaults to all databases.
The UI does not allow you to type a specific database name into the dropdown to aid in finding a specific database, which results in lots of scrolling.

When the SQL Search 2 database control has focus. Can you add support for typing the name of the database and have it narrow down the list as you type, and without using the mouse, select a specific database from the list.

Maybe also add an option to prevent SQL Search 2 from defaulting to All Databases. When the option it turned on, it would default to no database -- or be better at detecting the current database.
csuire
 
Posts: 6
Joined: Fri Feb 01, 2008 6:28 pm

Re: Multi-Database Issues

Postby SupiluliumaII » Tue Mar 24, 2015 10:46 am

csuire wrote:SQLSearch2 sometimes detects the current database.
Othertimes it defaults to all databases.

For servers with LOTS of database, it can be annoying when it defaults to all databases.
The UI does not allow you to type a specific database name into the dropdown to aid in finding a specific database, which results in lots of scrolling.

When the SQL Search 2 database control has focus. Can you add support for typing the name of the database and have it narrow down the list as you type, and without using the mouse, select a specific database from the list.

Maybe also add an option to prevent SQL Search 2 from defaulting to All Databases. When the option it turned on, it would default to no database -- or be better at detecting the current database.


I agree with the OP that the behaviour of SQL Search to sometimes default to "all databases" is an issue.
I could live with the extra scrolling and having to deselect and select databases, but the real problem is that when all databases are selected, SQL Search starts to index all those databases. On a server with 300+ databases that takes a lot of RAM on the client and eventually leads to SQL Search crashing and me having to restart SSMS.

Could you please fix this? I think SQL Search should either never default to "all databases" or have an option to disable automatic indexing of selected databases.
Thanks.
SupiluliumaII
 
Posts: 2
Joined: Tue Mar 24, 2015 10:08 am


Return to SQL Search 2

Who is online

Users browsing this forum: No registered users and 0 guests