Skip to content

SQL Search

Welcome to the SQL Search feature suggestion list. Find out more information about SQL Search at http://www.red-gate.com/products/sql-development/sql-search/

SQL Search

Categories

JUMP TO ANOTHER FORUM

(thinking…)

How can we improve SQL Search?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

12 results found

  1. Filtering lists need two extra actions: 'Select All' and 'Deselect All' for faster filtering

    Filtering lists need two extra actions: 'Select All' and 'Deselect All' for faster filtering

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  2. jump to search text

    In the old version, the display window of the selected object would jump right to the instance of the search term. Version 2 does not do this, it makes it less useful than the old version.

    I looked to see if it was an optional feature, but I couldn't find any options to adjust.

    12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Schema search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  3. Preview table contents in the bottom pane where SP previews are shown.

    The preview pane under the search results is wasted space when searching for tables.

    Tables should be previewed like SPs when highlighted in the search results, either the top n rows, or even just a list of columns in the table would be more useful.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    3 comments  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  4. banner

    Remove the banner "ad" at the bottom of the window when other RedGate products installed. I don't need a reminder to "Learn about RedGate essential SQL Server productivity tools for the DBA..." when I already have them installed and am using them

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  5. Support for Umlaut respectively mutated vowel

    We use german notation for database objects. For example a table could be named "Übersetzung". So you have the umlaut "Ü" in it. The SQL Search neglect this.
    It would be nice if SQL Search would support mutated vowels or minimum give a hint, that this is not supported.
    Thanks
    Antoine

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Data search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  6. allow text copy in the result panel

    After searching we try to copy some text (for example the stored procedure name) in the result panel. This fails with the error: "unsaved documents cannot be cut or copied to the clipboard...." (alert box)

    112 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    8 comments  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    completed  ·  Adam responded

    Here are the steps to fix this SSMS issue:

    - Restart SSMS
    - Go to Tools → Options
    - Expand “Environment” on the left and click the “Documents” item
    - De-select “Show Miscellaneous files in Solution Explorer”
    - Click OK

    In order for this to be effective, either restart Management Studio or close/save any unsaved query windows (after which point, new, unsaved query windows should not cause this problem any more)

    We are now closing this suggestion so that votes are reallocated.

    Thanks
    SQL Search Development Team

  7. To be able to select 2 or more object like Table and Views to search for, not to all or to only 1

    My idea is to search for the objects beginning with LPrg, but I want to have in the list only tables, views and SP, not index, tigers and so on.

    You combo box offer only All, only Tables,only views and so on, but there no option to select for example Table and Views. If I understand correct, the idea of SQL Search is to reduce time gone for navigation, but with this miss of option I’m lost between tigers, indexes and so on. They are 3 times more in numbers then Tables, views and SP. I need just table, views…

    25 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Data search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  8. Provide the column name when the match is a column

    At this time it just shows column match, but not the name of the column, making this only partially useful for detail on the column name and type I am searching for.

    22 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Schema search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  9. Allow OR/AND/NOT Searches

    Allow searches using any combination of AND/OR/NOT and parens. A minus in front of a keyword works for NOT, like Google does.

    81 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  10. Option to search jobs

    Frankly very surprised Version 1.0 didn't have this. Doesn't even seem like it would be a feature consideration. If you have a search tool, shouldn't it be expected to search the entire SQL Server, not just part of it? I wonder how many people assume it searches jobs, which after all are stored in a system database, and never realize they may be missing some references?

    63 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    4 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  11. Remember the location of the SQL Search toolbar

    Is there any way to make SSMS remember where the SQL Search toolbar is placed? Every time I start SSMS, SQL Search takes up an entire toolbar slot above my other two toolbars. I'd rather have it alongside the others leaving more screen real estate for scripts, etc

    20 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    5 comments  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  12. Let me configure the maximum number of results returned

    I understand the reasoning behind limiting the search results to 150 results, but it would be useful to have the ability to change this as needed.

    141 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    6 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    completed  ·  Adam responded

    Thank you for this suggestion. the new v2 release of SQL Search now allows you to lift the per-database limit for each search.

    The default limit is 500 results per database, However, it is also possible to configure this limit by following these steps:

    On 64-bit systems, create the registry key
    “HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Red Gate”
    if it does not already exist and
    “HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Red Gate\SQLSearch 2”
    if it does not already exist.

    Create the following DWORD (32-bit) value
    “HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Red Gate\SQLSearch 2\ResultsLimit”
    and set its data to what you wish the results limit to be (note that the registry editor works with Hexadecimal by default, so you may wish to change the base to Decimal when setting the value data).

    On 32-bit systems, create the registry key
    “HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate”
    if it does not already exist and
    “HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQLSearch 2”
    if it does not already…

  • Don't see your idea?