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/

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.

  1. automatic re-index

    re-index operation must be configurable. I had a big problem yesterday because I copied the source code from your UI and it was an old version. After re-indexing I got an updated version of the stored procedure. I was a big problem because I replaced a newest version on my server with an old one got from you UI.

    1 vote
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      0 comments  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
    • automatic re-index

      re-index operation must be configurable. I had a big problem yesterday because I copied the source code from your UI and it was an old version. After re-indexing I got an updated version of the stored procedure. I was a big problem because I replaced a newest version on my server with an old one got from you UI.

      0 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
      • Stop the search once started or at least control when it "starts"

        Add a stop/start button to the search process.
        If you change the criteria, it immediately starts searching for that criteria before you get a chance to change some of the other parameters.
        Worst case scenario it eats up all the memory and crashes SSMS if you search against "All Databases" on a production server.
        Give some control back to the UI.

        3 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
        • "your Favorite databases" checkbox

          In the Data-Base drop-down, Just below "All databases" checkbox,
          add "Favorite databases" checkbox, which will select all the databases that the current user marked them as his favorites in advance and they are saved on his computer.

          3 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
          • Hotkey for SQLSearch

            On my prior computer for years I had Ctrl-Alt-D configured to open Sql Search. Now I am no longer having that feature and I'm unable to figure out how to bind a SSMS hotkey to do this. SqlSearch should come with a hotkey to open it so that we can keep fingers on keyboard instead of mouse.

            1 vote
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
            • Very annoying that SQL search always trying to search ALLDatabases

              Very annoying that SQL search always trying to search ALLDatabases

              3 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • SQL Search : Ability to exclude database snapshots from the search scope

                I would like the ability to exclude database snapshots from the search scope of SQL Search.

                We have around 20 databases on our development server, with each having multiple snapshots are various times. When searching through all "databases", I want to exclude the snapshots.

                3 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • Provide a feature to search objects and column names of System Databases, that would become a great feature

                  Provide a feature to search objects and column names of System Databases, that would become a great feature. and also provide data search also.

                  3 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    0 comments  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
                  • 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.

                    19 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      0 comments  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
                    • Add GUI options to Add/Remove columns from search

                      It would be nice to have the option to show or hide some of the different columns in our search results. I rarely ever need to see the "Schema" or "Detail" columns in the search results. They are just real estate wasting columns for me 95% of the time I'm using SQL Search so it would be awesome if I could hide those for when I want to dock the SQL Search under the properties or object explorer panels.

                      6 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                      • Find and Replace would be very helpful

                        Find and Replace would be very helpful

                        1 vote
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
                        • 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…

                          24 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            1 comment  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
                          • Persist text size changes between search results

                            Search result text size is changeable using ctrl+click (thank you for that feature), but unfortunately it is not persisted between search results. Reading through search results can be much faster if the text size is a little smaller making this usable feature, but it loses all value when reading through a list of results.

                            5 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                            • Include Search inside synonyms objects

                              SQLSearch doesn't find keywords inside Synonyms. For instance I want to find all Synonyms regarding table MyTable

                              10 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
                              • Include in the top panel the type as it is in the sys.object table. So Calar function will be 'FN' for example.

                                Include in the top panel the type as it is in the sys.object table. So Calar function will be 'FN' for example.

                                1 vote
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
                                • 7 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Add "Select Top X Rows" and "Edit Top X Rows" when right-clicking a table in the search result list

                                    I would be a nice feature if it was possible to quickly select or edit top X rows (on tables) directly from the result list. Now I have to first "Select in Object Explorer" and select top rows from there. This feature would save me a lot of time.

                                    3 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Show modify_date of objects

                                      I would be great if we could see the last modify_date of the objects in the results grid and sort by last modified

                                      1 vote
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                      • There should be also table data search option

                                        It would be nice if we can search table data.

                                        10 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          1 comment  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Save results to a table

                                          It would be nice to be able to save the results to a table. An added bonus would be to be able to select which columns you would like to save.

                                          2 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 6 7
                                          • Don't see your idea?

                                          Feedback and Knowledge Base