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. Query Tab naming

    You could create a way that we can put a 'description' on the top of the script we are typing on the query window, so that when we move the mouse up to the tab title for unsaved scripts, a hint with this description will be shown instead of the defultt SSMS hit 'SQLSqueryX.sql - server.database.....'

    22 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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
    • Tab Groups

      Add the ability to define groups of tabs that are used regularly for different jobs. For instance--there is a group of scripts I use for month end processing and a completely different set of scripts I typically have open for daily processing. Monthly statement preparation and troubleshooting comprise another set of scripts. I'd like to be able to name groups of tabs and retrieve them based on that named grouping, while still being able to go back to what I was doing before the "interruption" that caused me to need a different set of tabs open.

      16 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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
      • Tab History Cloud Sync

        Option to sync/store tab history in the cloud, network share, or online share (aka One drive, Google drive, dropbox, etc.) That way you don't loose your history when you upgrade or change your computer and have to start all over again. It would also be nice to be able to sync between multiple computers.

        10 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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
        • Keep pinned status

          In SSMS 2016 you can now Pin tabs. When you close and re-open SSMS, it would be good if Tab History could remember, and restore, the pin status for each of the tabs as they are being restored.

          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

            1 comment  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
          • Add Last Execution Time (or last saved time) to results

            Either in the Tabs tab or in the display show that last time a query was saved/executed.

            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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
            • Improved Tab Navigation

              Provide a better tab list for navigation than the one supplied by SSMS when there are many tabs open, for instance a resizable "navigation" window (or even a navigation tab) that easily allows filtering/grouping by server instance, database, user defined, etc.

              As a complement to grouping tabs would be to allow naming, saving, closing, and opening of a "tab group" - related queries/script files that do not make up an SSMS "project" but are used for a particular purpose or go against a particular database, etc (user determines grouping criteria, see above). Furthermore, activating a tab group would bring its…

              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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
              • Restoring tabs based on SSMS version

                I had 2 instances of SSMS open, one was 2008R2 the other 2012.
                Each had 4 different tabs open.

                I closed both of the SSMS down, and then restarted, 2008R2 first then 2012.

                All 8 tabs reopened in the first (2008R2) SSMS.

                No tabs were restored in the 2012 SSMS.

                OK, this is a weird scenario, but wondered if SQL Prompt could remember tabs based on SSMS.

                Annoyingly though, if I had 2 SSMS 2008R2 open each with 4 tabs, then I would expect all 8 to appear in the first invocation of SSMS.

                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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
                • Tabs History Windows - Remember Each Tab's location/Window Panel

                  When saving and opening tab windows, it would be great if it remembered each tab's window panel. For example, I have SMSS open on a large high resolution monitor. Within SMSS, I have two windows panels opens open, the first panel with 3 tabs and the second panel with 4 tabs, so that I can simultaneously view and compare the results of two queries side-by-side. I then close SMSS saving all the tabs. When I reopen SMSS, all the tabs are correctly opened. However, instead of the tabs opening in their original two panels, all the tabs are now open…

                  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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
                  • Ping Tabs in History

                    It would be really nice to be able to pin a tab in the history. On a daily basis, I can work with dozens to hundreds of tabs. My tab history gets extremely cluttered with stuff I no longer need, but it buries the stuff I want to stay in my tab history.

                    That means I have two choices:
                    1. Scroll to the bottom of a very long list about 10 - 15 times and open then close the tabs I want to stay in history, just so that they are the most recent ones open. Then I can actually…

                    4 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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
                    • TAB HISTORY Restore Multiple Closed Tabs

                      Add a checkbox next to each closed tab history item, all multiple selection. Default should be unchecked. Easier way to recover a session of multiple tabs when session runs out of memory and a re-open of SSMS doesn't restore any or all tabs.

                      4 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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
                      • Different resulttab for comparing queries

                        When optimizing a query its good the have the queryresults to different resulttabs just like other vendors do. That way you can easily look at a version of the query that ran better/worse. Several others have this already and it would be a great completent to your excellent SQL Prompt.

                        3 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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
                        • Add the Results Row Count and execution run time

                          IT would be nice in the new SQL Tab Magic if I could see the Resulting row counts and the time it took to run next to the database name at the bottom.

                          3 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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
                          • Tab History - sort or filter on evironment

                            Allow me sort or filter the tab history list based on the environments that I have defined.

                            2 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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
                            • TAB History Option to Restore Previously Open SSMS Project

                              I always create an SSMS project to store the sql scripts I am working on for a given project. Simply restoring my tab settings does not work for me. I need to have the associated project opened as well. Have disabled this option for now. Causes me problems when I get to work on the displayed scripts, and adding new ones, without opening my project first.

                              2 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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
                              • Add "closed timestamp" to tabs on tab history

                                It would be great to find out when a tab was closed on the tab history form.

                                Thanks

                                2 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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
                                • Tab History - Open all Closed Tabs

                                  Tab History - Open all Closed Tabs. Add a button to open all Closed Tabs in history. Possibly add a warning that this will take up much RAM.

                                  2 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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Keep the Tab history even when there is a cleanup at the Windows profile

                                    In my current company, the IT is outsourced and we all are working in a commond Windows Domain. Also, the way to work is to RDP to a server where we have our "desktop" to work with.

                                    As I don't like to RDP, I use my own PC. Problem is that every time I log out, I loose the history of SSMS, and also the Magic Tabs history.

                                    If you can do something about that, would be great!

                                    Keep up with the good job!

                                    2 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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
                                    • multiple "Workspace"

                                      Allow the current tabs to be saved (and then reloaded). Having multiple Workspaces like this would be of great benefi

                                      2 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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Import "Tab History" feature of SQL Prompt in Visual Studio, just like it is in SSMS.

                                        Import "Tab History" feature of SQL Prompt in Visual Studio, just like it is in SSMS. That feature is beautiful just the way it is in SSMS, would be nice to have it in Visual Studio as well.

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

                                          We’ll send you updates on this idea

                                          0 comments  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Add the option to Disable Tab History (Tab Magic)

                                          I would like to be able to completely disable the Tab History feature, as it is resource intensive (especially with large scripts).

                                          Our programers write their TSQL in SSMS and are using SQL Prompt for its auto-complete. they are not even aware of the Tab History feature, they do not use it (which is good for our case - they actually save their work from time to time...), but it affects performance on their computers to the point they come to me (DBA) complaining about the **** SSMS...

                                          It would also be nice to be able to leave only the…

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

                                            We’ll send you updates on this idea

                                            1 comment  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1
                                          • Don't see your idea?

                                          Feedback and Knowledge Base