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. In SQL Search results, show the rowcount for tables.

    Either provide a column with the table's rowcount or allow a way to filter tables that do not contain rows. This would provide a way to eliminate looking into tables that do not have rows and would save a considerable amount of time when looking for data within tables.

    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 →
    • Add support for distinct search results

      Add a checkbox for distinct and if selected list each object the search term is found in ONCE. Instead of having 1,200 entries for 23 distinct objects, I'd then see only the 23 lines.

      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 →
      • Pneumonic Search

        http://www.sqlsmash.com/ - Search Database Objects
        I use this *all the time*... it would be nice if the same feature were a part of the redgate toolset

        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 →
        • Please let me select and change fonts for SQL Search.

          I'd like to use my preferred monospaced font cosnsistent with SSMS. I cant find any option to change font in SQL search.

          It'll be absolutely great if I could change font for SQL search results.

          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 →
          • A set of defaults. When opened it always selects "All Objects". It would be nice to have a way to limit this to "X" by default.

            A set of defaults. When opened it always selects "All Objects". It would be nice to have a way to limit this to "X" by default.

            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  ·  Flag idea as inappropriate…  ·  Admin →
            • Search for the literal asterisk(*)?

              Is there a way to search for the literal asterisk(*)? I need to find all "select * from..." and modify to select column names instead in legacy projects. I can't do exact match since it may not be on one line.

              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 →
              • 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 →
                • Display only matches found in an object - allowing expansion of script

                  When results are displayed from clicking on a search result row. Show only rows that match the search criteria (e.g. 2 rows match, show those two rows), allowing for + sign above and below to expand display showing script before and/or after.

                  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 →
                  • Search sometimes doesn't work due to no access to cache

                    I've faced it a couple of times so far and today I found the root cause with help of support.
                    Sometimes the search doesn't work although the searching object exists. In the log of 'SQLSearch 2' I did find as below:
                    ---
                    03 Oct 2017 12:28:13.252 [25] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Exception while indexing Jobs on HOST:
                    Exception: The process cannot access the file 'C:\Users\KN******\AppData\Local\Red Gate\SQLSearch 2\Indexes\HOST.__SQLSearch_JobsIndex__' because it is being used by another process.
                    03 Oct 2017 12:28:15.528 [121] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Exception while re-indexing Database on HOST:
                    Exception: The process cannot access the file 'C:\Users\KN******\AppData\Local\Red Gate\SQLSearch 2\Indexes\HOST.Database' because it…

                    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 visual marks on result panel

                      On the right side of document panel, show a graphic bar to help identifiy the locations of the items found inside the document, like the left bar on this image: https://www.scootersoftware.com/images/TextCompare.png

                      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 →
                      • change date

                        Woud be good to see the last change date

                        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 →
                        • SAFE RENAME any object across all databases

                          SAFE RENAME any object across all databases

                          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 →
                          • create a list of interesting objects

                            I search for several objects from the result I found what I need and I select it to be add to my list. So My list will be updated.
                            And an extra feature to be able to have some list of objects for example one for pricing (sub system) one for customers info ...

                            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  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
                            • Open in Excel

                              Would be nice to have option Open in Excel the search result.

                              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  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                              • Search for list of methods in CLR assemblies

                                I have built a SQL server CLR assembly that is just a C# library with methods that can be called from SQL code. It would be nice to have these methods show up in the search results.

                                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 →
                                • Is it possible to just print the result list of objects, not the whole code

                                  just want to be able to print out the list of objects that contain a string, like all the SP's, so print all the columns except for the detail column.

                                  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…)
                                    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Improve Exact Match

                                    Improve exact match. When searching for an exact phrase, allow case sensitive search, and the use of AND/OR/NOT or %.

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

                                      40 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…)
                                        3 comments  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
                                      • 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 →
                                        • Search on Azure Datawarehouse

                                          SQL Search works on Azure Databases, but not on Azure DataWarehouses.
                                          Hope some other users world like to enable this feature too.

                                          12 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 →
                                          ← Previous 1 3 4 5 8 9
                                          • Don't see your idea?

                                          Feedback and Knowledge Base