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

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

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

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

                        36 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 →
                            • temporal

                              Redgate search can find Temporal Tables, but double-clicking the result is unable to locate it in the SSMS object explorer. Presumably this is because the Object Explorer has a suffix of (System-Versioned) in the name.

                              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 →
                              • 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 →
                                • Show in results window each location of matching text with ability to jump to next found match (like search feature in SSMS)

                                  Similar to SSMS now where it highlights the side bar with each instance of the matched string, in the results window show me each instance that text was found.
                                  Also like the SSMS find feature, allow me to jump to each instance of the matching text within the page.

                                  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 →
                                  • Send to a PowerShell as a variable

                                    When selecting multiple objects, on the right-click menu, allow the user to send the list of results to the clipboard as an array/variable they can then use in PowerShell to iterate over with whatever command they desire.

                                    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 →
                                    • Disable usage reporting

                                      During installation, I cleared the option to send usage statistics back to RedGate.

                                      So imagine my surprise when the log file shows multiple "Usage reporting request made to" events!

                                      Respect your users' selections - if I choose not to submit usage reports, DO NOT SUBMIT USAGE REPORTS!

                                      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 →
                                      • One Index folder for all user on a multi user DB server to reduce space requirement

                                        On a DB server that is accessed by more than one user all user have their own index folder in the %USERPROFILE tree. Would it be possible to have one single folder for all user to reduce space requirements?

                                        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 →
                                        • Export list of objects results in a search, to txt file o allow copy to clipboard the column with the objects name.

                                          Export list of objects results in a search, to txt file o allow copy to clipboard the column with the objects name.

                                          8 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…)
                                            2 comments  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 8 9
                                          • Don't see your idea?

                                          Feedback and Knowledge Base