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

130 results found

  1. 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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. 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)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. 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…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. 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…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. 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

    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  ·  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)
  6. 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…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. 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…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. 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…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. 5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. 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…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. 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)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. 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)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. 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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. 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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. 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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. 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)
    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)
  17. SQL Search does not return users as part of the returned results. This could be useful when searching in multiple databases.

    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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. Enable users to search for user-defined types. Sometimes there is a certain change and SQL search will not show relevant fields of a user-defined type that matches the search criteria.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. It would be great if you could attach to an SSAS server and search the databases (cubes) for text. I'm mainly interested in the queries used to populate the tables, but I could see it being useful to search for text anywhere in the database.

    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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. If an SSIS Catalog is chosen as a database, search the SSIS packages within for the text. I'm not sure how easy it would be to show the results, but even if the results were shown in the XML file format that would be better than nothing.

    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  ·  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)
  • Don't see your idea?