SQL Prompt

Welcome to the SQL Prompt feature suggestion list. Find out more information about SQL Prompt at http://www.red-gate.com/products/sql-development/sql-prompt/.

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

How can we improve SQL Prompt?

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

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Indent Guides Line

    Sometime, my sql query script have too much nested condition and I need to see the indent guides line like this image:
    https://lh4.googleusercontent.com/-qmpRo6zwZTo/U6EzoIkdw7I/AAAAAAAAAYs/ctAXWq5nPwc/w725-h316-no/Untitled.png
    It would be awesome if you include this feature in this product.

    30 votes
    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)

      We’ll send you updates on this idea

      0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
    • Add a new "Modify" menu item when right clicking views in Object Explorer

      To get an ALTER script for an existing stored proc or UDF you just need to right click it in Object Explorer and select Modify. For views you can't do this. You have to select "Script view as.." then "Alter to..." then "New query editor window". It's only two extra mouse clicks but they are two very annoying mouse clicks! I was hoping this would have come back for SQL2012 as you used to be able to do this in SQL2000, but it hasn't. Redgate to the rescue?

      17 votes
      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)

        We’ll send you updates on this idea

        4 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
      • Visual indication on open transaction

        Show a visual indication when open transactions exist in a query window (@@TRANCOUNT > 0)

        It could be changing the background color of the query window, and a number in the status bar showing the current transaction depth or something like that.

        17 votes
        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)

          We’ll send you updates on this idea

          2 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
        • Multiple rows of tabs

          If I have more open tabs than can horizontally fit the window SSMS does not show all of them but instead there is a dropdown in the right upper corner. I would prefer if I could have multiple rows of tabs instead, like in VS. Since it does not seem likely that MS is going to implement that soon, can it be done in SQL prompt?

          17 votes
          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)

            We’ll send you updates on this idea

            0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
          • Better tab management

            1)Automatically name tabs generated by modifying a stored procedure in the Object Explorer. I noticed you added the functionality to right-click on a procedure name in-line and generate an ALTER script. That's AWESOME, and even more awesome is the fact that the tab is named by default. Usually tabs in SMS have some dynamically-generated name that's useless.
            2) add ability to rename a tab without saving the contents of the tab. Just a right-click->Rename
            3) Hovering over a tab should give you a pop-up with the first dozen or so lines of text in that tab.

            15 votes
            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)

              We’ll send you updates on this idea

              1 comment  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
            • Rename Open Tabs

              I noticed the Tab History that you can rename closed tabs. It would be great if one could rename open tabs. I am constantly flipping between tabs thinking Query1 is the one where I querried table A, Query6 was the one where I updated reference table B. etc etc,,, It's a total pain.

              12 votes
              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)

                We’ll send you updates on this idea

                1 comment  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
              • Prefered server Connection List

                When working all day long with serveral SQL servers, its really annoying to click on "change connection" button + enter the server name you want to connect to, and enter credential.... It would be really great we we would have a "server connection list" where we could build into settings.... So i could add all my server i'm use to connect everyday, and specifying the USERNAME + PASSWORD + Default DB..... So in one-two click, i could switch to another server really quicly

                12 votes
                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)

                  We’ll send you updates on this idea

                  4 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                • More "power" to tabs

                  1) add a possibility to set custom colours to tabs
                  2) pin in/pin out tabs
                  3) automatically set colour for executing queries tabs
                  4) add possibility to pop-up windows when query execution finish

                  12 votes
                  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)

                    We’ll send you updates on this idea

                    5 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                  • Search Results in Grid Mode

                    Find all occurrences of your search string in the results in datagrid mode. I know I should and could do this in SQL but sometime it is handle to find the customers name in a large set of rows.

                    9 votes
                    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)

                      We’ll send you updates on this idea

                      0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                    • Shortcut for Switching Styles

                      Can you add "choose style" or "switch style" to the commands section, as a drop down, so that it can be added to the SQL PROMPT toolbar? Or possibly as a hot key menu option?

                      I switch styles often. There's the style I like to work in, a style suited for debugging, and the style that management likes the code to be posted with (in TFS.) Being able to switch between them is very helpful. but, going to SQL Prompt --> Options --> Styles --> Selecting Style "with the mouse" is time consuming.

                      Thanks for your consideration!

                      Lawrence Barnes

                      8 votes
                      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)

                        We’ll send you updates on this idea

                        under review  ·  2 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                      • Organize objects in SSMS with a folder stucture

                        The reason I would like to see the folders is strictly for organizational purposes. I have so many procedures and tables in one database that I have to scroll through them all to find what I’m looking for. If I could organize by schema (or however I choose) and very quickly and jump back and forth between the different folders, that would help me out tremendously. The SQL filter function is so slow when going back and forth.

                        What if I could organize sql instances that I'm connected to in one SSMS. Production and Development folders?? Just another thought.

                        8 votes
                        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)

                          We’ll send you updates on this idea

                          2 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                        • Table Data Preview

                          When I hover over a table name, and I can see the script, as well as a summary including data types - I'd also like to be able to see a preview of the table's data. I understand temporary tables wouldn't be able to do this. It would save me the time of writing a select statement to view the top 50 rows.

                          7 votes
                          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)

                            We’ll send you updates on this idea

                            2 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                          • compare

                            It would be nice to compare 2 objects (tables / stored proc ets), by right clicking on them and select to compare (lig scema compare).

                            I am using to to clean up an old DB with a lot of copyed code and tables.

                            7 votes
                            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)

                              We’ll send you updates on this idea

                              5 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                            • Customize Keyboard Shortcuts

                              It would be perfect if we could change the keyboard shortcuts, I like to use Ctrl+Enter shortcut to execute current statement (like Oracle SQL Dev) and I can't change the default Shift+F5 on SQL prompt.

                              6 votes
                              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)

                                We’ll send you updates on this idea

                                2 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                              • Have a Documentation tab next to the script & summar tabs on the table/stored proc popup window that shows the Sql Doc documentation.

                                This would make Sql Doc a lot more useful if the information you entered was displayed along with the other nicely formatted information in the popup window in Sql Prompt for table, stored procs, etc.

                                6 votes
                                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)

                                  We’ll send you updates on this idea

                                  1 comment  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                • toggle SQL Prompt from toolbar

                                  I frequently need to work on longer procedure or scripts, and the longer the script gets Sql Prompt gets more and more bogged down, to the point I just turn it off. It would be nice to be able to toggle it from the toolbar rather than open the options to un-check 'Use SQL Prompt'

                                  6 votes
                                  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)

                                    We’ll send you updates on this idea

                                    0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                    started  ·  Paul StephensonPaul Stephenson responded

                                    Not from the toolbar, but with SQL Prompt 5.2 you can easily turn prompting on and off with Ctrl+Shift+P or directly on the SQL Prompt 5 menu.

                                  • Remove Red Gate toolbar

                                    This is an old problem that just won't go away.

                                    The Red Gate toolbar that holds the SQL Prompt icons (Tab History, Add-ins, SQL Test, SQL Search) will not persist it's state in SSMS. You can move it, but it comes back to the same place on it's own row. You can delete it, but it comes back again.

                                    Recommend (a) making the toolbar's state persistent in SSMS and (b) added a feature to the Options menu that allows the user to remove it.

                                    Using SQL Prompt 6.4.0.678 on SSMS 11.0.5058.0 (2012).

                                    6 votes
                                    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)

                                      We’ll send you updates on this idea

                                      7 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                    • export to excel options

                                      Hi - export to excel is a great feature. if it could be extended in 2 ways it would be even better.

                                      1. copy the sql used to produce the results (and date, server info) into a separate tab called 'sql' or something. this way data extracts will be 'auditable' and re-runnable.

                                      2. have some export options (top row = bold, highlighted, freeze top row). column autowidths applied.

                                      the second one can be done with a macro in the excel template but would be a nice to have.

                                      5 votes
                                      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)

                                        We’ll send you updates on this idea

                                        1 comment  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Change Table Icon for Trigger

                                        Can we get an change in the table icon, or an indicator in intellisense (ideally both), that lets someone know there is a trigger on a table? Triggers are often hidden, and it would be nice to have them marked in SSMS, as well as noted when someone is altering or querying a table.

                                        5 votes
                                        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)

                                          We’ll send you updates on this idea

                                          0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Ugliest parts of SSIS is the lack of an acceptable sql editor. I'd buy just for that if it worked.

                                          In SSIS objects like a Source, when you configure sql directly, it would be huge if this replaced the lame, nearly useless, text editor that pops up.

                                          5 votes
                                          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)

                                            We’ll send you updates on this idea

                                            0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5
                                          • Don't see your idea?

                                          Feedback and Knowledge Base