SQL Prompt Feature Suggestions

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=137.

How can we improve SQL Prompt?

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 vote and comment on it.

If it doesn't exist, you can post your idea so others can vote on it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas

  1. Highlight the invalid objects within the Alter script(s)

    Highlight the invalid objects within the Alter script(s)

    10 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Forgot password?
      Create a password
      I agree to the terms of service
      Signed in as (Sign out)
      Close
      Close
      You have left! (?) (thinking…)
      1 comment  ·  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.

      8 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Forgot password?
        Create a password
        I agree to the terms of service
        Signed in as (Sign out)
        Close
        Close
        You have left! (?) (thinking…)
        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.

        2 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Forgot password?
          Create a password
          I agree to the terms of service
          Signed in as (Sign out)
          Close
          Close
          You have left! (?) (thinking…)
          0 comments  ·  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.

          2 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Forgot password?
            Create a password
            I agree to the terms of service
            Signed in as (Sign out)
            Close
            Close
            You have left! (?) (thinking…)
            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.

            2 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Forgot password?
              Create a password
              I agree to the terms of service
              Signed in as (Sign out)
              Close
              Close
              You have left! (?) (thinking…)
              1 comment  ·  Find Invalid Objects  ·  Flag idea as inappropriate…  ·  Admin →
            • Don't see your idea?

            SQL Prompt Feature Suggestions

            Feedback and Knowledge Base

            (thinking…)