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.

133 results found

  1. When searching for a string, include a count of instances within each object within search results

    When using SQL Search to find a column name within objects, it would be extremely helpful to have an additional column that totals the number of instances of that search string within the search results. Clicking on a row in the search results shows the first instance of the string within the object but if it's a stored procedure, function, trigger, table, or query it's helpful to be able to see the total number of instances of that string within the object.

    Also in the object definition window, it would be really nice to be able to click a button…

    4 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  ·  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

  2. Azure Active Directory - Universal with MFA Authentication for SQL Search

    Would be good that SQL Search authenticated through Azure Active Directory - Universal with MFA.

    SQL Search version: 3.4.2.2567
    Error log:
    [78] ERROR RedGate.SQLSearch.Addin.Tab.DatabaseConnector - Could not load database list
    System.Data.SqlClient.SqlException (0x80131904): Cannot open server "XXXXX" requested by the login. The login failed.
    ...at RedGate.SQLSearch.Addin.Tab.DatabaseConnector.OnlineDatabasesForInstance(String connectionString)
    Error Number:40532,State:1,Class:20
    [1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy
    Exception: Exception has been thrown by the target of an invocation.
    ...at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler)

    58 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  ·  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

  3. Add Hotkeys to SQL Search

    I would like to be able to activate SQL Search from the keyboard instead of clicking the icon on the toolbar. In addition, I would like to have keystrokes to toggle some options like whether it Matches on Name, Text, or Column.

    When I'm searching for objects with names containing "xyz" I'd like to do it quickly from the keyboard without having to navigate with my mouse.

    This should be an easy request to fulfill and will give you points in the Accessibility category.

    9 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  ·  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

  4. User Defined Table Types in SQL Search

    Currently its impossible to see User Defined Table Types at all in SQL Search. Please add this functionality. Other 'Type' objects would also be great.

    https://forum.red-gate.com/discussion/86737/can-sql-search-show-user-defined-types

    It breaks your flow when rather than using search, you have to manually navigate down the object explorer

    8 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

  5. In the script panel you highlight the matches but buttons to jump forward and back between matches in the script would be great!

    5 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

  6. Add a connect button to SQL Search

    While not frequent, there are times when I start SQL Search and all of the fields are disabled (see attached image). The only resolution is to exit SSMS and restart.

    1 vote
    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  ·  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

  7. Allow for keyboard shortcuts

    Your sql search tool is great, while using it. However, it would be even better, if you could allow a user a way to kick off the tool without the toolbar button. I use VS and management studio without toolbars and via keyboard shortcuts. I would love to see a keyboard shortcut entry to kick off a SQL Search, and\or a means via menus.

    Thank you.

    6 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

  8. How about a version of SQL Search that does not stop working each time an update is done to SSMS?

    1 vote
    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

  9. Highlight / Copy doesn't seem to work in the Script panel

    When you click on a match and see the script in the lower panel, I can highlight with my mouse but Ctrl-C doesn't copy what I've highlighted to the clipboard. That would be handy!

    5 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  ·  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

  10. global filter at the top of the databases tree

    At the moment, you can filter on each node; tables/views/SP's etc. This takes ages often.

    I would like to see a filter up at the top of the tree, that filters the whole tree as you type. No dialog, just a filter text entry box at the top.

    1 vote
    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

  11. Habilidad de copiar código de la ventana de vista previa sin haber grabado un documento en SPID abierto

    Hola, trabajo todos los días en SQL Management Studio y SQL Search es una herramienta clave para mí, he notado que puedo copiar código que sale en la vista previa si tengo SPID abierto y el código que se muestra esta grabado en un archivo, pero muchas veces estamos modificando consultas o procedimientos y deseamos reutilizar código, se podrá habilitar el comando copiar aunque no tenga grabado el archivo o código con un SPID abierto? sería de gran ayuda gracias.

    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…)
    0 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. Ability to filter searches to just selected table(s)

    Add the ability in SQL Search to filter one selected tables within a database.

    1 vote
    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  ·  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

  13. exclude schema list

    It would be nice to have a list of schemas that you don't want to search in.

    5 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  ·  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

  14. Include a dark mode

    Allow users to select to use a dark theme for SQL Search, ideally this would pick up from their settings (if on Windows at least)

    24 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

  15. always exclude database

    Would be nice to always exclude a list of databases from search.
    I know this can be done by deselecting them but when you are going between servers you always need to deselect them again and again.
    There are some databases so big that the search hangs indefinitely.

    2 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  ·  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

  16. enable/disable trigger icon

    I was wondering if trigger icon could have a status indicator, whether it is disabled or not.
    currently (ver 3.5.2) it only shows like this.

    ![current](https://us.v-cdn.net/6029854/uploads/editor/j4/h8s0bbhrm7l7.jpg)

    But i'd like to have an indicator on the icon whether it's disabled or not

    ![Sql alt](https://us.v-cdn.net/6029854/uploads/editor/qj/l9luliu7klu1.jpg)

    1 vote
    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  ·  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

  17. SQL Server 2019 Support for SQL Search

    SQL search needed for SQL server 2019

    1 vote
    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  ·  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

  18. Add ability to search for identifiers (tables, columns, indexes, etc.)

    There is currently no way to search for an identifier, e.g., a column name, without also matching text that contains that identifier. For example, if I want to search for a column called ExampleColumn but ignore ExampleColumn2, BadExampleColumn, etc., I could try the "Match whole words only" option. I want it to find all of these:

    SELECT ExampleColumn FROM ExampleTable;
SELECT ExampleColumn, OtherColumn FROM ExampleTable;
SELECT [ExampleColumn] FROM ExampleTable;
SELECT et.ExampleColumn FROM ExampleTable et;
SELECT * FROM ExampleTable WHERE ExampleColumn=3;
SELECT SUM(ExampleColumn) FROM ExampleTable;

    but only the first three are found. Without the whole words option, it would match all…

    1 vote
    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  ·  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

  19. Save previous search settings.

    Save all of the previous search settings for dropdowns, checkboxes and search text. Keep SQL Search tab open on next launch of SSMS.

    23 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  ·  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

  20. sql search stil greyed out, when do you fix this before asking for new features make the old one run well

    sql search stil greyed out, when do you fix this before asking for new features make the old one run well

    1 vote
    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
2 4 5 6 7
  • Don't see your idea?