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. 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 →
  2. 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 →
  3. 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 →
  4. Improve exact match. When searching for an exact phrase, allow case sensitive search, and the use of AND/OR/NOT or %.

    5 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 →
  5. 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 →
  6. Similar to SSMS now where it highlights the side bar with each instance of the matched string, in the results window show me each instance that text was found.
    Also like the SSMS find feature, allow me to jump to each instance of the matching text within the page.

    14 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 →
  7. During installation, I cleared the option to send usage statistics back to RedGate.

    So imagine my surprise when the log file shows multiple "Usage reporting request made to" events!

    Respect your users' selections - if I choose not to submit usage reports, DO NOT SUBMIT USAGE REPORTS!

    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  ·  Flag idea as inappropriate…  ·  Admin →
  8. Export list of objects results in a search, to txt file o allow copy to clipboard the column with the objects name.

    18 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
  9. It would be useful to be able to export result set of SQL Search to a SQL script file (or any other format).

    19 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  ·  Flag idea as inappropriate…  ·  Admin →
  10. The product requires you to have at least read access to all databases on provided server... because when the product opens... and db access is lacking... then USER is failing login attempts on PRODUCTION SERVERS to which user has no access. This creates GREAT FRUSTRATION for DBA and AUDITing groups.

    24 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 →
  11. It would be nice to add a search on the data type

    9 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 →
  12. Add a stop/start button to the search process.
    If you change the criteria, it immediately starts searching for that criteria before you get a chance to change some of the other parameters.
    Worst case scenario it eats up all the memory and crashes SSMS if you search against "All Databases" on a production server.
    Give some control back to the UI.

    24 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 →
  13. SQL Search version 2.3 does not search name\definition in master.sys.server_triggers.

    41 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 →
  14. It would be nice to have the option to show or hide some of the different columns in our search results. I rarely ever need to see the "Schema" or "Detail" columns in the search results. They are just real estate wasting columns for me 95% of the time I'm using SQL Search so it would be awesome if I could hide those for when I want to dock the SQL Search under the properties or object explorer panels.

    20 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 →
  15. Looking up any values in any DB with the brute force approach.
    --This feature will look at every table and every column for a string, number, or datetime value, etc
    --It supports begins with, ends with, and contains for strings and returns a query of results
    --including the count of total matches on the table and the sql needed to query that result up.
    --It's also support multiple options like contains, begins with, ends with, and exact match.

    --Secondly it also supports number and date searches, xml etc.

    I have already implemented above features with a stored procedure, and hope…

    49 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  ·  Flag idea as inappropriate…  ·  Admin →
  16. SQLSearch doesn't find keywords inside Synonyms. For instance I want to find all Synonyms regarding table MyTable

    43 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  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
  17. 69 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  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
  18. I would be great if we could see the last modify_date of the objects in the results grid and sort by last modified

    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  ·  Flag idea as inappropriate…  ·  Admin →
  19. The search for through functions, store procs, views, tables is great. But it would help if one was able to search through SSRS reports as well.

    This will enable one to find where functions, store procs etc. are been used. As the "Show Dependencies" is limited to a specific DB and does not have the ability to "look" into deployed reports.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  20. Once the list is generated allow the printing or export of the list.

    Cheers

    12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?