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. 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 →
  2. 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 →
  3. 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 →
  4. 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 →
  5. 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 →
  6. 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…)
    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Fill searcheable servers from "Registered Servers" as well as Object Explorer and allow multiple server search simutaneously.

    15 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  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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 →
  9. 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…)
    2 comments  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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.

    50 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 →
  11. It would be nice to be able to filter results on schema. We have a number of large databases with multiple schemas. When we're looking for a common phrase or word, it would be nice to be able to select a schema or multiple schemas to narrow down the results.

    33 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. There's already been a suggestion to add next/previous matches, and this doesn't replace that, but helps to show where in the script the next match is (a bit like the difference highlighter on the vertical scroll bar in SQL Compare)

    95 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  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  13. Search for object that synonym is created for (select name, baseobjectname from sys.synonyms - baseobjectname)

    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  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
  14. Can the gui be changed to include line numbers on the left hand side. It'll make it easier to find the actual line in long procs etc.

    37 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 →
  15. 190 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    9 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Add "Find Next/Previous" buttons in the Text area, so, it will jump to the next occurrence of the searched term (highlighted) in the text.

    THNX
    Jermy

    145 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 →
  17. For example on a stored procedure, it's time consuming to first click select object in explorer, then right click on the object, then click modify. For a table, same, but clicking design. Plus sometimes if the database sproc isn't expanded yet its slow as the left side menu bounces around expanding first...

    204 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    9 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  18. This is in all of your other applcitions, I was a little surprised it wasn't in SQL Search.

    146 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 →
  19. You cannot open multiple search tabs in SSMS. This might be by design, but the ability to have multiple search tabs open at the same time rather than having to open new SSMS windows would make the product more flexible and allow easier searching into "child" issues found from the first search result.

    76 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  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  20. Here is an example of a search of what is returned if I search the following text "acftfltinfo"

    SELECT *
    FROM Test.DBO.VWFLTINFO3 (NOLOCK)
    -- From acftfltinfo Removed
    where SchdDepDate>= @FromDate

    But this code has been updated to the new view, If I was able to exclude comment text out of my search then this text would not return. I would I
    to exclude this object because I do not care about it.

    Also for the most part the view dependencies does not work for all case since it will only look in…

    338 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

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