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 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…)
    1 comment  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  2. 1 vote
    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 →
  3. 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…)
    1 comment  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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…)
    1 comment  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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  ·  Flag idea as inappropriate…  ·  Admin →
  6. Please add the ability to search indexes.

    6 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 →
  7. 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…)
    0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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…)
    0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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…)
    1 comment  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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…)
    1 comment  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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…)
    1 comment  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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 →
  17. option to ignore comments when searching for a string.
    I need to search for SP having "with" statements and its picking up tons of SP with the word "with" in comments

    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 →
  18. On my server there are dozens of databases, each project encompasses several at a time. It would be nice to save groupings of databases so that I can select multiple databases that are relevant for a particular project without sifting through a long checklist picking specific databases.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  19. We have over 200 tables and over 1000 stored procedures. I often need to search on two words. The current "Match whole words only" literally searches for "this word", but I often need it to search for all objects that have exactly "this" and "word". When I search try without the "Match whole words only", I end up with a LOT of results that have words that are similar to "this" and "word", but aren't an exact match.
    I've also tinkered with the wildcards, but that only seems to apply to on character at a time. Maybe I'm doing something…

    4 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 →
  20. Having the search start automatically with all database is frustrating when you have hundreds of databases on an instance.
    You should be able to initiate the search when you're ready, or stop the one that is currently running.

    7 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 →
  • Don't see your idea?