SQL Scripts Manager

I suggest you ...

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. Make adding own scripts more easy (graphical) to do.

    Adding own scripts is not an easy job to do now. Perhaps you could make it more graphical, copy/paste, drag/drop sort of thing?

    44 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…)

      Hi,

      We now have a beta version of a UI tool to help people generate scripts for use in SQL Scripts Manager. If you’re interesting in trying it out, here’s a link to it:
      http://www.red-gate.com/SSMScriptGenerator/v1

      There’s also an article about using it at http://www.simple-talk.com/sql/sql-tools/fast-and-free-sql-scripts-managers-script-generator/

      Thanks,

      Colin.

    • This is a great util. It would the best tool ever if you could just cut and paste our own code in it

      This is a great util. It would the best tool ever if you could just cut and paste our own code in it instead of having to play with XML files. There was a tool called CodeKeeper that had the ability to cut and paste our custom code into it and it made it great and easy to use.

      Now with the easy to add code function the next thing I would add is a easy way to upload our custom code to your site for you and others to share and use. Kind of like facebook but for SQL…

      24 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…)

        Hi,

        We now have a beta version of a UI tool to help people generate scripts for use in SQL Scripts Manager. If you’re interesting in trying it out, here’s a link to it:
        http://www.red-gate.com/SSMScriptGenerator/v1

        There’s also an article about using it at http://www.simple-talk.com/sql/sql-tools/fast-and-free-sql-scripts-managers-script-generator/

        Thanks,

        Colin.

      • store in cloud

        scripts would then be accessible from any location (most of us use multiple machines foten remote) and could also make scripts 'public' for code sharing. Was hoping that is what the 'share' button was going to be for.

        17 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…)
        • bring in the ability to manage the scripts that I have created

          searching, grouping of my scripts is unreliable at best having a UI to manage them would be great.

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

            Hi,

            We now have a beta version of a UI tool to help people generate scripts for use in SQL Scripts Manager. If you’re interesting in trying it out, here’s a link to it:
            http://www.red-gate.com/SSMScriptGenerator/v1

            There’s also an article about using it at http://www.simple-talk.com/sql/sql-tools/fast-and-free-sql-scripts-managers-script-generator/

            Thanks,

            Colin.

          • 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…)
            • Choose Servers from SQL Central Management Server

              I've created a Central Management Server in SQL and it would be nice to have an option or preference to set the server list to choose from it.

              10 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…)
              • I would love to be able to populate a combo from a select

                If we could populate a combobox list from a select, the values in the list would change dynamically based on current values from the database. This makes the interface much more like a standard database application tool would create. Awesome first version, Red Gate!

                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…)
                • include a way of specifying which SQL Server versions the script works on

                  A lot of the scripts have things that won't work on some versions of SQL [especially 2000 :-(] but there is no way to show this in the meta data for the scripts. With new versions of SQL Server due there is a good chance some current scripts will stop being suitable in future too

                  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…)
                  • Search Scripts by Multiple Selection of Tags

                    I like the quick search capability of selecting a tag and seeing only the scripts that match that tag.

                    I belive making the application able to select multiple tags and filtering the script pane accordingly would be a good addition.

                    I work with several disparate systems on a daily basis that all accomplish the same taks. So it would be nice to be able to multiple scripts by say (grouping goal, specific goal, system) and quickly get to the required script for execution when needed with just 2 or 3 clicks. Currently I'm having to search through about 40 directories…

                    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…)
                    • Make the xml document separate from the script

                      If the xml document is a separate entity from the sql script that would still allow scripts to be dropped in the folder as is and visible but with no propertes. Just add an optional form that creates an xml document with the same name with all the desired properties such as title, description, owner, and so on.

                      5 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  ·  Admin →
                      • BUG: columns displayed in different order than selected??

                        SELECT name = ISNULL(s1.name, s2.NAME), r1 = s1.rows, r2 = s2.rows, diff = s2.rows - s1.rows
                        FULL OUTER JOIN

                        will show name, r2, r1, diff in the result grid
                        instead of name, r1, r2, diff

                        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…)
                          1 comment  ·  Admin →
                        • Allow for server paths for network sharing the repository. I.E. \\servername\path\path\xxx

                          Well, I cannot figure out how to make the repository available to all the DBAs. There is no option to paste in a path like \\servername\path\etc

                          You can only choose a folder on your drives or make a new folder on a drive locally. I have the current version loaded.

                          Was this written by a Ma and PA operation with 4 employees?

                          This is no good.

                          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…)
                          • Add refresh button on results screen

                            Add a refresh button to the results screen to allow re-executing the query without clicking Back, clicking Run, then having to resize/maximize the screen again.

                            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…)
                            • folderize the left pane for organization / structure

                              Such as SQL Version folders so users can refer back to older versions, Author Folders, Folders for types of scripts, etc. This tool works great if all you have are 10-20 scripts, but hundreds ....

                              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…)
                              • Bug: button bar tooltip handling problem.

                                When moving the curser over the Button Bar that has "Show Scripts Folder", "Give Feedback" etc. The length of the tooltip changes, but the text does not change. If the text is shorter than the length, the excess space is solid black. When the text is longer than the tooltip, the text is truncated.

                                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…)
                                • SQLCMD Mode

                                  To be able to run the script in SQLCMD Mode = ON

                                  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…)
                                  • Add Import Script Functionality.

                                    It Would be very useful if you could point to a TSql script and it will create the relevant xml file etc... for you. I think it will simplify things quite a bit

                                    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…)
                                    • Add views to the table control and/or create a view control

                                      The control for table includes tables only and does not include user defined views. There is no control that gives a dropdown of views. You could make the table control configurable: tables only/views only/both tables and views. And/or create a separate view control.

                                      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…)
                                      • 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…)
                                        • Bug: documentation says it supports SQL 2000 but error messages says NOT!

                                          Tried to run a script on a SQL 2000 box but got the error message: SQL Scripts Manager supports only SQL Server 2005 and later. While the documentations says SQL Scripts Manager is compatible with:

                                          * SQL Server 2000, 2005, 2008, 2008 R2
                                          * Windows 2000, Windows XP, Windows Vista, Windows 7, Windows Server 2003, Windows Server 2008

                                          I actually wrote my script to overcome a bug that is only in SQL 2000 - works fine in 2005 and above.

                                          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…)
                                          ← Previous 1
                                          • Don't see your idea?

                                          Feedback and Knowledge Base