Skip to content

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

133 results found

  1. Add a option when you right click on the stored procedure you found to script it to an alter page similar to how you can do that if you find a nested SP in your code.

    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  ·  Data search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. Currently, SQL Search does not show precision and scale for numeric/decimal data types. I erroneously thought a column was defined without those specified when I say the SQL Search results for a table I was looking at.

    Please add precision and scale for decimal/numeric columns to the create table display

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. 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…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. 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…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. table: msdb.dbo.sysjobsteps
    column: database_name

    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  ·  Data search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. Would be nice to always exclude a list of databases from search.
    I know this can be done by deselecting them but when you are going between servers you always need to deselect them again and again.
    There are some databases so big that the search hangs indefinitely.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. Database Triggers are missing in result set.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. When SQL Search finds synonyms, they're only labeled as "other". Please label them Synonyms and show the definition in the bottom panel

    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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. As VS 2019 Preview is out, we have still been waiting for VS 2019 support

    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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. 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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. 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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. 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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. 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…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. Similar to Select Object in explorer. It would select the object and either execute it or create the Execute to New Query in Editor Window. Like the two options available by right clicking the stored procedure from the object explorer.

    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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. Feature to exclude expression in the search.
    Example:
    Search by "Test", but exclude finds where "Test" is part of "tbl_Test"

    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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. SQL Search does not return users as part of the returned results. This could be useful when searching in multiple databases.

    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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. sql search stil greyed out, when do you fix this before asking for new features make the old one run well

    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  ·  Data search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. There is currently no way to search for an identifier, e.g., a column name, without also matching text that contains that identifier. For example, if I want to search for a column called ExampleColumn but ignore ExampleColumn2, BadExampleColumn, etc., I could try the "Match whole words only" option. I want it to find all of these:

    SELECT ExampleColumn FROM ExampleTable;
    SELECT ExampleColumn, OtherColumn FROM ExampleTable;
    SELECT [ExampleColumn] FROM ExampleTable;
    SELECT et.ExampleColumn FROM ExampleTable et;
    SELECT * FROM ExampleTable WHERE ExampleColumn=3;
    SELECT SUM(ExampleColumn) FROM ExampleTable;
    

    but only the first three are found. Without the whole words option, it would match all…

    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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. SQL search needed for SQL server 2019

    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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  • Don't see your idea?