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. 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 →
  2. 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 →
  3. 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 →
  4. 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 →
  5. 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 →
  6. 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 →
  7. 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 →
  8. 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 →
  9. 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 →
  10. 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 →
  11. 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 →
  12. 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 →
  13. Give the users the ability to set default databases to search in, so that when ever the SQL Search is done, it saves them the time to select their mostly searched databases

    77 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 →
  14. 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 →
  15. I would like to see history of my search and to be able to re use it fast, right away in search box. The idea is that almost all the time I’m working with 2-4 tables, SP and views and it will be helpful to me to get last 10 used search text at once. A text is selected when I do Navigate to Object function.

    The list could be like combobox or like auto complete /with text that has been used already/.

    I’m sure this will be in help for all persons using you great search tool. I’m using…

    43 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 →
  16. 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 →
  17. it would be very helpful to be able to copy and paste a list of objects from the search grid rather than the whole line.

    13 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 →
  18. when selecting a server, sql search should remember which databases on that server you last searched.
    I often want to just search 5 db's on the 1 server, and re-selecting them each time i open search is annoying. (the selection gets forgotten when you search on a different search, or close the window)

    26 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. I want to be able to export the list of results for a search in a file.

    71 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 →
  20. Default objects filter (ignore jobs, constraints, triggers, and other...but include tables, sprocs, views, functions). EVERY time I start search I have to turn off the objects I don't want (and RARELY want).

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