SQL Search Feature Suggestions

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/

If you have any questions, need help or have found a bug in SQL Search, please visit the forums at http://www.red-gate.com/messageboard/viewforum.php?f=114.

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 vote and comment on it.

If it doesn't exist, you can post your idea so others can vote on it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. Let me configure the maximum number of results returned

    I understand the reasoning behind limiting the search results to 150 results, but it would be useful to have the ability to change this as needed.

    109 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…)
      5 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • Option to include/exclude comments in search

      Here is an example of a search of what is returned if I search the following text "acft_flt_info"

      SELECT *
      FROM Test.DBO.VW_FLT_INFO3 (NOLOCK)
      -- From acft_flt_info Removed
      where Schd_Dep_Date>= @FromDate

      But this code has been updated to the new view, If I was able to exclude comment text out of my search then this text would not return. I would I
      to exclude this object because I do not care about it.

      Also for the most part the view dependencies does not work for all case since it will only look in the current database and also does not work…

      70 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 →
      • Allow OR/AND/NOT Searches

        Allow searches using any combination of AND/OR/NOT and parens. A minus in front of a keyword works for NOT, like Google does.

        62 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 →
        • 54 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  ·  Flag idea as inappropriate…  ·  Admin →
          • Option to search jobs

            Frankly very surprised Version 1.0 didn't have this. Doesn't even seem like it would be a feature consideration. If you have a search tool, shouldn't it be expected to search the *entire* SQL Server, not just part of it? I wonder how many people assume it searches jobs, which after all are stored in a system database, and never realize they may be missing some references?

            43 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  ·  Flag idea as inappropriate…  ·  Admin →
            • Format and color code the code view section

              This is in all of your other applcitions, I was a little surprised it wasn't in SQL Search.

              34 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 →
              • Add "alter object" next to "select object in object explorer"

                For example on a stored procedure, it's time consuming to first click select object in explorer, then right click on the object, then click modify. For a table, same, but clicking design. Plus sometimes if the database sproc isn't expanded yet its slow as the left side menu bounces around expanding first...

                26 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 →
                • allow text copy in the result panel

                  After searching we try to copy some text (for example the stored procedure name) in the result panel. This fails with the error: "unsaved documents cannot be cut or copied to the clipboard...." (alert box)

                  26 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  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                  • Add "Find Next/Previous" buttons in the Text area

                    Add "Find Next/Previous" buttons in the Text area, so, it will jump to the next occurrence of the searched term (highlighted) in the text.

                    THNX
                    Jermy

                    23 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  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                    • Provide the column name when the match is a column

                      At this time it just shows column match, but not the name of the column, making this only partially useful for detail on the column name and type I am searching for.

                      21 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 →
                      • Multiple searches open at the same time

                        You cannot open multiple search tabs in SSMS. This might be by design, but the ability to have multiple search tabs open at the same time rather than having to open new SSMS windows would make the product more flexible and allow easier searching into "child" issues found from the first search result.

                        21 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…)
                          4 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                        • Search for synonym base object name

                          Search for object that synonym is created for (select name, base_object_name from sys.synonyms - base_object_name)

                          20 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 →
                          • Go to definition in search resultset

                            It could be helpful to go to definition of the selected object directly in a new SSMS window

                            20 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  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
                            • Add option to the context menu for a result to open the item for modification

                              Double clicking a result should open the item for me to modify. Most of the time I'm looking for a stored procedure, often I've got the exact name or I know roughly the name and I'm using SQL Search to quickly get to it. When I select the item in the results I'd like to be able to right click and go straight to modify it.

                              At the moment I can double click and jump to that item in the Object Explorer, then right click and go to modify (or use the keyboard to right click and then press Y…

                              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  ·  Flag idea as inappropriate…  ·  Admin →
                              • Search and Replace

                                The ability to search for text in all object and replace them with your other text.

                                Motivation:
                                For e.g. Currently I needed to change the size of a certain parameter (varchar(50) to varchar(255) that is used in 90 stored procedures. I had to open up all 90 stored procedures, and then did a search and replace.

                                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…)
                                  3 comments  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
                                • Remember the location of the SQL Search toolbar

                                  Is there any way to make SSMS remember where the SQL Search toolbar is placed? Every time I start SSMS, SQL Search takes up an entire toolbar slot above my other two toolbars. I'd rather have it alongside the others leaving more screen real estate for scripts, etc

                                  15 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 →
                                  • Option to search only object names

                                    To have an option to seach only the object names and when the term matches on object name, do not list the matches on text because it's obvious.

                                    14 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  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Exclude List like SQL Compare

                                      As in SQL Compare, allow us to filter out extraneous objects, e.g., sp_MS% for replication objects I don't care about.

                                      13 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 →
                                      • Dynamically update SqlServer instance dropdown

                                        As connections to different Sql Servers are opened and closed, it would good if the dropdown of instances could reflect that. Currently if Search is open and I open a connection to a new instance I have to close Search, make sure I click on something in the new instance in Explorer and then re-open Search.

                                        13 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 →
                                        • Export filtered list

                                          When I've performed an Impact Analysis, allow me to "hide" an object that is of no interest in the object list, then "export to..." Excel-format, or tab-delimited list, so I can pull the list into my Word or other impact document/checklist.

                                          13 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  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1
                                          • Don't see your idea?

                                          SQL Search Feature Suggestions

                                          Feedback and Knowledge Base