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

124 results found

  1. Currently if I search for x y (x,space,y), it will return all instances of x or y.
    If I make it "x y" it finds nothing. There are many times when I want to find the coexistence of two very common terms, so having the latter search (or a variation) return results would be helpful.

    15 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. Similar to Select Object in explorer. It would select the object and either execute it or create the Execute to New Query in Editor Window. Like the two options available by right clicking the stored procedure from the object explorer.

    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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. Save all of the previous search settings for dropdowns, checkboxes and search text. Keep SQL Search tab open on next launch of SSMS.

    15 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. I would like to have the ability to turn off the "auto search" function. Whenever I enter a search phrase, I feel "rushed" to get it entered before the auto-search kicks in. Many times it starts finding results as I'm typing and then does not search again when I complete my typing. At the point I have to force a re-index.

    It would be helpful to be able to turn that off and then pressing Enter or using a separate search button would initiate the search.

    8 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. When you are looking at table in the bottom panel, it would be nice if you changed the columns and rows ever so slightly. Instead of making the single dash continuous but made the two horizontal lines continuous instead, then, when you copy and paste this into a Markdown file, it will format it properly

    Example

    from...

    [dbo].[foo]

    Column | Datatype | Computed value

    Id | int |

    ...

    to...

    [dbo].[foo]

    Column | Datatype | Computed value
    ----------------------|-------------------|-------
    Id | int |

    ...

    1 vote
    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. 1 vote
    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. Allow to search Azure Managed Instances

    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)
  8. SQLSmash (http://www.sqlsmash.com) has a wonderful "Go To Object" tool that I use regularly. It helps me navigate to SQL objects quickly without having to point and click. All I have to do is type CTRL+, and start typing the name of the object. It will filter the names based on what I type, and when I click enter it will select the object in Object Explorer.

    It is much better at finding tables, views, & stored procs on the fly than SQL Search. It is especially helpful when working in multiple databases simultaneously. I had previously posted this…

    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)
  9. Please add ability to search foreign keys.

    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  ·  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)
  10. Please add the ability to search indexes.

    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)
  11. I love the colored tabs but to better know which server/database I'm working with I'd like to see the server and its children in the Object Explorer with the same colored background to match it's tabs. This would help to visually to associate what server I'm working with when I have a lot of servers and databases open.

    2 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)
  12. Only that, being able to add or delete columns in the results search grid. Would be great.

    4 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. should be able to search for columns with a specific columntype

    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  ·  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)
  14. Once you have a list of all matching objects, have the option to select them all and script them to a new window.

    4 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. I just started using SQL search and the tool is able to find words I filter by however I have scroll through lines of code in my results to see the high lighted word I specified.Can you enhance the SQL Data Search feature to return only the highlighted line of code in my SQL search versus returning the whole script.

    22 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  ·  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. I wish to view the result columns hierarchically: Database -> Schema - > Object. But at present I'm limited to the existing order, which is reverse in my mind: Object -> Schema - > Database. Bonus if the columns are draggable.

    6 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. A Restart SQL search button: Many times Redgate can stop working/throw an error (can be system problems, not Redgate itself), however, the search interface continues to accept input but return 0 results

    A Restart Search button would really help and solve this issue without having to restart SSMS everytime it happens.

    2 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. Please build an unified Update Manager to manage all your product updates in accordance with the client license.
    It's a very time consuming and laboring task to enter each and every program or tool and do an individual update for each one.

    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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. SQL Search tries to runs the search as the logged in user but sometimes that will not work specifically on cross domain scenarios with a one way trust.
    In these cases we have to use the RunAs Windows command with SSMS so we can connect to the database on the other domain.

    SQL Search does not do the same behavior as most times indexing or any search will fail because it cannot connect to the database because it uses the logged in user account

    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)
  20. 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  ·  Admin →
    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?