SSMS Plugin that analyzes the database

• 
  Hi Sanjiv
  
  do you mean "Find Invalid Objects" ? -> You'll get it with an right click on the database and in the contextmenu click on "Find Invalid Objects".
  
  Jürgen
  

  bauerju April 17, 2023 12:23

  - 0 +
• 
  HI@Sanjiv, Thank you for your post.
  
  It sounds like you might be referring to SQL Prompts SQL Code Analysis function:
  
  https://documentation.red-gate.com/sp/sql-code-analysis
  

  Ben_P April 17, 2023 14:00

  - 0 +
• 

  Ben_P said:

  HI@Sanjiv, Thank you for your post.
  
  It sounds like you might be referring to SQL Prompts SQL Code Analysis function:
  
  https://documentation.red-gate.com/sp/sql-code-analysis
  

  Hi @Ben_P,
  It might have been this tool however the tool used to have an option to run all it's analyis on the entire database and come back with a list of recommendations. I don't see an option to run the analysis across the database. https://share.cleanshot.com/nnWLP1MP  It seems more like prompting for hints and suggestions as you trying SQL in the SQL Editor.
  
  Any suggestions? For example which action can I take to scan the entire database and report on missing keys on Foreign Keys among other things?
  
  Thanks,
  Sanjiv
  
  
  
  

  Sanjiv April 17, 2023 16:03

  - 0 +
• 
  aha, I see the option "Show List of Code Analysis Issues..." but it's disabled. Any idea why?
  
  https://share.cleanshot.com/DqhL0jR7
  

  Sanjiv April 17, 2023 16:13

  - 0 +
• 
  SQL Prompts SQL Code Analysis function seems to work only with SQL in an editor, it does not scan the entire database for issues like I mentioned. Really wish I was able to track down the tool I used for this.
  

  Sanjiv April 17, 2023 17:25

  - 0 +
• 
  SQL Prompt should be able to scan the entire DB for invalid objects as shown here:
  
  https://documentation.red-gate.com/sp/sql-refactoring/refactoring-an-object-or-batch/finding-invalid-objects#:~:text=In the Object Explorer, right,script in the lower pane.
  

  Ben_P April 28, 2023 15:34

  - 0 +
• 

  Ben_P said:

  SQL Prompt should be able to scan the entire DB for invalid objects as shown here:
  
  https://documentation.red-gate.com/sp/sql-refactoring/refactoring-an-object-or-batch/finding-invalid-objects#:~:text=In the Object Explorer, right,script in the lower pane.
  

  But missing keys on Foreign Keys is not returned in the Invalid Objects report.

  SanjivJ April 29, 2023 22:35

  - 0 +

Add comment

Please sign in to leave a comment.