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. Find Invalid Objects In - Instance and Database drop lists need to be wider to see entire name

    Instance and Database drop lists need to be wider to see entire name

    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  ·  Find invalid objects  ·  Flag idea as inappropriate…  ·  Admin →
    • Automate Find Invalid Objects through Script or API

      Enable/create a way to write a script or automate this feature so it can be run frequently (i.e. weekly basis) getting the list of invalid objects as the output instead of manually going to SSMS and right-clicking each and every single database.

      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  ·  Find invalid objects  ·  Flag idea as inappropriate…  ·  Admin →
      • Ability to call "find invalid objects" from T-SQL

        Our organization would like to have a report of invalid database objects. SQL prompt has this functionality built in but I'd like to call this feature from T-SQL and display the results on a report.

        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  ·  Find invalid objects  ·  Flag idea as inappropriate…  ·  Admin →
        • Add existence check to the drop statements generated by find invalid objects.

          Add existence check to the drop statements generated by find invalid objects. If there are several objects that all have the same invalid dependency it would reduce the number of errors after that object has been dropped in the script.

          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  ·  Find invalid objects  ·  Flag idea as inappropriate…  ·  Admin →
          • Find not matched datatypes

            Implicit data type conversion produces poor performance. Provide feedback that column data types do not match.

            For example: A varchar(50) (e.g., col1, below) is being joined to a CHAR(10). (e.g. col2, below)

            This would be appropriate at least in the following areas of SQL:

            * FROM..ON... col1=col2
            * UPDATE..SET col1=col2
            * INSERT (<col1>) SELECT <col2>
            * WHERE.. col1=col2

            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  ·  Find invalid objects  ·  Flag idea as inappropriate…  ·  Admin →
            • Enhance "Find Invalid Objects" to find exec of stored procedure with incorrect parameters

              Enhance "Find Invalid Objects" to find exec of stored procedures with incorrect parameters

              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  ·  Find invalid objects  ·  Flag idea as inappropriate…  ·  Admin →
              • Find Invalid Objects - exclusions

                I would like to set exclusion rules in the 'Find Invalid Objects' tool so that I don't see hundreds of invalid objects that I know are fine.

                Specifically, I want to exclude references to missing objects called '%tmp%', but I imagine there are probably other exclusion rules that would be useful.

                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

                  1 comment  ·  Find invalid objects  ·  Flag idea as inappropriate…  ·  Admin →
                • Ability to filter columns in invalid object list

                  Ability to filter columns in invalid object list

                  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  ·  Find invalid objects  ·  Flag idea as inappropriate…  ·  Admin →
                  • Ability to create report

                    Need the ability to create a report form find invalid objects. Something like the reports created in SQLCompare would be ideal

                    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  ·  Find invalid objects  ·  Flag idea as inappropriate…  ·  Admin →
                    • Bug: Identifies strings as invalid column name

                      The following code snippet throws an invalid Column Name 'D' in a stored procedure that has QUOTED_IDENTIFIERS set to OFF

                      ... IF @Status = "D" ...

                      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  ·  Find invalid objects  ·  Flag idea as inappropriate…  ·  Admin →
                      • Divide by zero detection

                        Hi
                        A very useful feature would be a warning that a particular piece of code might give a divide by zero error. Not exactly an invalid object but a potential banana skin
                        Thanks
                        Joe

                        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  ·  Find invalid objects  ·  Flag idea as inappropriate…  ·  Admin →
                        • dynamic SQL

                          Some of our databases contain a large number of Dynamic SQL.

                          Find invalid objects lists each and every proc containing DSQL as invalid. If it cannot evaluate the DSQL it should not include any proc with DSQL in the results, or at least give me the option of filtering them out.
                          As it is the feature is pretty useless and instead I have to use some other method using the sql_expression_dependencies and dm_sql_referenced_entities views to get what I want.

                          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  ·  Find invalid objects  ·  Flag idea as inappropriate…  ·  Admin →
                          • Ability to Save invalid objects list instead of re-running entire database each time

                            When you are working with a rather large database it would be nice to be able to save a list of invalid objects to come back rather than having to re-run through the entire database again.

                            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

                              1 comment  ·  Find invalid objects  ·  Flag idea as inappropriate…  ·  Admin →
                            • Find Invalid Objects on all databases

                              I would like to be able to run 'Find Invalid Objects' globally as well as for individual databases.
                              When I look at the output in a csv there is a column for the database name which seems totally redundant when only 1 database is being considered. If this could run on all databases for a server then repeat offenders could be easily identified - the same invalid object in more than 1 place would be a good candidate for cleaning up and with SQL MultiScript this could make a fairly slow and laborious task almost easy.

                              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  ·  Find invalid objects  ·  Flag idea as inappropriate…  ·  Admin →
                              • Extend 'Find Invalid objects' to find other 'problems'. E.g. unaliased fields, wildcards etc.

                                It would be lovely to find other elements in the database that may not stop it from working right now but are 'problems waiting to happen'. Other examples might be to search for field names that clash with reserved terms.

                                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  ·  Find invalid objects  ·  Flag idea as inappropriate…  ·  Admin →
                                • display # of objects searched

                                  In the header add the number of objects searched in the database.

                                  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  ·  Find invalid objects  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Don't see your idea?

                                  Feedback and Knowledge Base