How can we improve SQL Prompt?

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
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Stuart Davis shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base