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

    We're glad you're here

    Please sign in to leave feedback

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

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

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

    We're glad you're here

    Please sign in to leave feedback

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

    52 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)
  6. SQLSearch doesn't find keywords inside Synonyms. For instance I want to find all Synonyms regarding table MyTable

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

    We're glad you're here

    Please sign in to leave feedback

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

    We're glad you're here

    Please sign in to leave feedback

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

    We're glad you're here

    Please sign in to leave feedback

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

    96 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  ·  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)
  12. 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…

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

    We're glad you're here

    Please sign in to leave feedback

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

    42 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  ·  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. 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).

    27 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)
  16. In search result windows , multiselect is possible. On right click give option to script out selected objects.

    Workaround i use for now:
    What i usually do is open sql compare alongside and then select results from a single database and compare them to an empty database, script all out, and then replace create statements with alter.

    33 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)
  17. Fill searcheable servers from "Registered Servers" as well as Object Explorer and allow multiple server search simutaneously.

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. Chose schema from combo box and all tables, view-s, procedures, functions, .... are filtered by schema in Object Explorer.

    10 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)
  20. When I change server SQL Search indexes all databases on that server before I can do anything, this takes ~ 1 min.

    Please, if you could preselect only the database that is default for the current user on the server.

    This would speed up my work considerably.
    This was not an issue before multiple database search.

    Best regards.

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