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. Currently, SQL Search does not show precision and scale for numeric/decimal data types. I erroneously thought a column was defined without those specified when I say the SQL Search results for a table I was looking at.

    Please add precision and scale for decimal/numeric columns to the create table display

    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 →
  2. Would be good that SQL Search authenticated through Azure Active Directory, so I could release this tool to many users on my Azure SQL Databases.
    If not possible, would be nice to choose which SQL account to authenticate instead of my current account.

    28 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  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
  3. I would like to be able to use the found objects in other programs (e.g. my text processor/notepad/email)

    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  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  4. As VS 2019 Preview is out, we have still been waiting for VS 2019 support

    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 →
  5. Please add support fpr COLOR THEME'S

    6 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 →
  6. Sometimes when server is changed it automatically starts Reindex for all databases. Even if one database was selected later, it continue re-indexing and it could be very long. Is it possible to add Stop Reindex button to stop the process?

    15 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  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
  7. It would be very beneficial if I could search for objects with a certain schema across the databases I choose. I.e. SQL Search trigger on letter-sequences in schema names, just as in table or column names.

    As it is, I can only find those objects if they are referenced elsewhere with their schema given (e.g. a stored procedure or a view will give me a hint that a schema exists in a database in a galaxy, far, far away).

    12 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  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
  8. Allow multiple searches in many search tabs.
    I want to search two different things and have the search results side-by-side.

    7 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 →
  9. 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 →
  10. The search facility doesn't stop even if you close the window and starts again with the same search. It doesn't have any button to stop the search if some inputs are wrong.

    24 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 →
  11. Please could you put the "Exact Match" feature back, it was very useful.

    16 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. Ability to maintain settings between searches. When I switch back and forth and open and close it, it goes back to SEARCH ALL, but when I am working, I am usually focused on something and it's quite painful to have to reset the settings almost every-time., We need a checkbox option to PERSIST SETTINGS.

    When I am working on something I am usually working in one or two databases but we have 50 databases, I don't need to search all those all the time. I am usually looking for where column names are within tables, I love all the features…

    10 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. Periodically I'll search stored procedure and functions for specific text and I'll get a lot of hits, only to discover that the hit was on a comment.

    For example if we're trying to remove a specific piece of code from all stored procedures, a DBA may make a comment "Removed XXX from stored procedure". Providing the ability to "Not search in comments" would provide a true list of areas that contain the offending code.

    19 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. When showing results on a table definition, show the nullability defined for it as well as any default value. Now, I see three columns: name, datatype and computed value. Please add two more: Null and Default, preferably in the order: Name, Type, Nullable, Computed, Default

    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 →
  15. It would be useful to have the option to exclude disabled jobs from the search.

    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  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
  16. 1) The last dropdown just shows me the alias names I use to connect to databases so I have no idea which user I'm doing the search under which impacts results based on the privilleges. This should clearly show which user it's searching under please.
    2) I'm sat here right now, I've select 1 database to search against out of 300. Yet my search results coming back (after 20 minutes of waiting) keeps including ALL database. I've closed down the search window and tried again, same result. why?
    3) Needs to be able to export results from the search window…

    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  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  17. I'd like to use my preferred monospaced font cosnsistent with SSMS. I cant find any option to change font in SQL search.

    It'll be absolutely great if I could change font for SQL search results.

    11 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  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  18. A set of defaults. When opened it always selects "All Objects". It would be nice to have a way to limit this to "X" by default.

    11 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 →
  19. Do not start indexing automatically but let user to start it.
    Our two database servers contain many databases. When I switch from one to another, the index is automatically started with the database dropdown box selected all databases as default. It crashes my SSMS a few times or when it did not crash, I need to wait long time to wait it to finish the indexing.

    56 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
  20. Would be nice to have option Open in Excel the search result.

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