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

  1. Please provide an option to save the search results to a file. This is very helpful when there are a lot of objects that match the search criteria.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
  4. It remembers the last search term, but not which databases I limited to the last time I searched. So everytime I open it, it tries to search multiple databases that I don't have permissions to. At least once a week I get asked by the DBA's what on earth I am doing.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
  5. It remembers the last search term, but not which databases I limited to the last time I searched. So everytime I open it, it tries to search multiple databases that I don't have permissions to. At least once a week I get asked by the DBA's what on earth I am doing.

    0 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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.

    8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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)
    You have left! (?) (thinking…)
    0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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)
    You have left! (?) (thinking…)
    0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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)
    You have left! (?) (thinking…)
    1 comment  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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)
    You have left! (?) (thinking…)
    1 comment  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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!

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  13. 4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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)
    You have left! (?) (thinking…)
    0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  15. It would be nice to have a list of schemas that you don't want to search in.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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)
    You have left! (?) (thinking…)
    0 comments  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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)
    You have left! (?) (thinking…)
    0 comments  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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)

    16 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 6
  • Don't see your idea?