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?

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

        18 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…)
                    • 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…)
                      • 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…)
                        • 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…)
                          • Remember results screen size and window state

                            Remember results screen size and window state. If it was maximized or sized a certain way, show it in the same location next time a query is executed.

                            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…)
                              • Example from help page doesn't work on version 1.2

                                Copy and pasting this code causes and error in SSM. "mode" is not valid.

                                <control type="list" id="options">
                                <height>100</height>
                                <width>220</width>
                                <mode>one</mode>
                                <list>
                                <item>SYSTEM_DATABASES</item>
                                <item>USER_DATABASES</item>
                                <item>ALL_DATABASES</item>
                                </list>
                                </control>

                                1 vote
                                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…)
                                • Return results from raiserror

                                  If use the following convention in lots of scripts/stored procedures:

                                  --determine Office Id
                                  Select @office_id = Office_Id from Lookup_Office where Office_Description = @office_description

                                  set @count = @@rowcount

                                  If @count <> 1
                                  Begin
                                  Raiserror('An error was generated looking for the Office.', 18,1)
                                  Return
                                  End

                                  All script manager does is report 'Failed'. Can it please return the raiserror message so I can see where in the script it did fail?

                                  Ta

                                  Dave J

                                  1 vote
                                  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 never get a result when I run a script

                                    When I run a script I don't get any result shown anywhere.

                                    Best regards
                                    Norbert

                                    1 vote
                                    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…)
                                    • Initiate a voting drive on the connect item to make the ssms template explorer refreshable.

                                      Initiate a voting drive on the connect item to make the ssms template explorer refreshable. Using the export scripts from phil factor this is an issue. http://connect.microsoft.com/SQLServer/feedback/details/338542/ssmss-sql-server-template-doesnt-refresh-automatically

                                      1 vote
                                      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 better tooltips on the results screen for long cell content

                                        Add tooltips that show more of the cell content when the text in the cell is long. For example, running "CPU-intensive queies" you can't see much of long sql statements in the tooltip. You have to double click to see cell content.

                                        1 vote
                                        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…)
                                        • Better formatting on the Cell Content screen

                                          Make the Cell Content screen format CR/LF correctly instead of auto wrapping everything. Possibly give a checkbox to do so (and remember the setting). For example, running "CPU-intensive queies" returns cells that show the SQL statement. The statement would be more readable if the existing line breaks in the statement were preserved. Also allow showing sql syntax coloring like you see when you click "Script Details" or the "View Script" button. Maybe a checkbox to enable/disable that since it won't always be SQL in the cell content. Or allow the script author to denote in the XML file which result…

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

                                          SQL Scripts Manager

                                          Feedback and Knowledge Base