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

(thinking…)

How can we improve SQL Search?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

133 results found

  1. Option to include/exclude comments in search

    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…

    345 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    7 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  2. Add "alter object" next to "select object in object explorer"

    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...

    212 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    9 comments  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  3. Add regular expression support

    193 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    9 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  4. Format and color code the code view section

    This is in all of your other applcitions, I was a little surprised it wasn't in SQL Search.

    153 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    3 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  5. Add "Find Next/Previous" buttons in the Text area

    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

    153 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  6. Coloured 'hotspots' on the scroll bar to show where matching references are

    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)

    100 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    3 comments  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  7. Ability to set default databases to search in

    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)
    Close
    Close
    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)
    Close
    Close

  8. Multiple searches open at the same time

    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.

    78 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    4 comments  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  9. Search for synonym base object name

    Search for object that synonym is created for (select name, baseobjectname from sys.synonyms - baseobjectname)

    74 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Schema 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)
    Close
    Close

  10. Add support for Regex search

    73 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Schema 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)
    Close
    Close

  11. Do not start indexing automatically but let user to start it.

    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.

    72 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    7 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)
    Close
    Close

  12. Export the result list to Excel or other format

    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)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  13. Azure Active Directory - Universal with MFA Authentication for SQL Search

    Would be good that SQL Search authenticated through Azure Active Directory - Universal with MFA.

    SQL Search version: 3.4.2.2567
    Error log:
    [78] ERROR RedGate.SQLSearch.Addin.Tab.DatabaseConnector - Could not load database list
    System.Data.SqlClient.SqlException (0x80131904): Cannot open server "XXXXX" requested by the login. The login failed.
    ...at RedGate.SQLSearch.Addin.Tab.DatabaseConnector.OnlineDatabasesForInstance(String connectionString)
    Error Number:40532,State:1,Class:20
    [1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy
    Exception: Exception has been thrown by the target of an invocation.
    ...at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler)

    58 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  14. Choose users default database first (upon changing server)

    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)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  15. Looking up any value in any DB, returns Tables/Columns/Rows in any DB per any value that you inputted

    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)
    Close
    Close
    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)
    Close
    Close

  16. Include Search inside synonyms objects

    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)
    Close
    Close
    You have left! (?) (thinking…)
    4 comments  ·  Schema 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)
    Close
    Close

  17. I would like to see history of my search and to be able to re use it fast, right away in search box.

    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)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  18. sql search remembers database filter selection for each server

    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)

    45 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  19. Ability to search triggers on servers (master.sys.server_triggers)

    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)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Schema 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)
    Close
    Close

  20. Display line numbers

    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.

    40 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
← Previous 1 3 4 5 6 7
  • Don't see your idea?