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. 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 →
  2. 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 →
  3. 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 →
  4. 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 →
  5. 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 →
  6. When I do a search, the results pane that contains the text of the object I currently have selected will highlight the search term within the text, but if the object has a large amount of text, I need to scroll and find it. A notch on the scrollbar, like what Google Chrome does with a find-on-page Ctrl+F search, will help with zeroing in on the term within the object's text.

    9 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 →
  7. When Displaying the search results that match a table column, include default value and nullable in the results.

    Additionally allow Select object in Object Explorer to select the matched column.

    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 →
  8. When SQL Search finds synonyms, they're only labeled as "other". Please label them Synonyms and show the definition in the bottom panel

    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 →
  9. 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 →
  10. 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 →
  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. 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 →
  13. 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 →
  14. 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 →
  15. 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 →
  16. 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 →
  17. 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 →
  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. It remembers the last search term, but not which databases I limited to the last time I searched. So everytime I open it, it tries to search multiple databases that I don't have permissions to. At least once a week I get asked by the DBA's what on earth I am doing.

    0 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 →
1 2 3 4 6 Next →
  • Don't see your idea?