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

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

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

    151 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. This is in all of your other applcitions, I was a little surprised it wasn't in SQL Search.

    150 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)
  6. 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)
    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. 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)
  8. 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)
    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. 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)
    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. 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)
  11. 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)
    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)
  12. 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)
  13. 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)
    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)
  14. 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)
  15. 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)
  16. 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)
  17. 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)
  18. 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)
  19. 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)
  20. 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.

    39 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)
← Previous 1 3 4 5 6 7
  • Don't see your idea?