Find invalid objects via SQL

• 
  Hi Marc,
  
  There's no way to trigger find invalid objects directly from SQL at the moment. We are doing some minor improvements to find invalid objects for the next release of Prompt and so I'm wondering if we could include some changes to help you. What would be the ideal way that this would work for you?
  
  Any more details on what you'd like to use it for would be really useful!
  
  Thanks,
  Aaron.

  Aaron L May 14, 2015 04:41

  - 0 +
• 
  Hello Aaron,
  
  I would also like this feature. As part of our production deployment process I would like to be able to confirm via a SQL statement that there are no-invalid objects in *ANY* of the production user databases. If there was an output which confirmed the results that we could keep for SOC purposes (i.e. Database Name checked and the results) that would be very helpful. Right now i have to do each data base one at a time and take a screen print for the documentation and this is time consuming.
  
  Thank you!

  WindyCityGirl June 23, 2015 14:06

  - 0 +
• 

  WindyCityGirl wrote:

  Hello Aaron,
  
  I would also like this feature. As part of our production deployment process I would like to be able to confirm via a SQL statement that there are no-invalid objects in *ANY* of the production user databases. If there was an output which confirmed the results that we could keep for SOC purposes (i.e. Database Name checked and the results) that would be very helpful. Right now i have to do each data base one at a time and take a screen print for the documentation and this is time consuming.
  
  Thank you!

  
  Hi - I've emailed you a workaround directly.

  David Atkinson July 13, 2015 19:34

  - 0 +
• 
  I realise this is a few years old now, but I'm trying to do the same thing. Has there been any progress on this since this was originally raised?

  jamieburns March 05, 2018 09:59

  - 0 +
• 
  I'm thinking of using Prompt's 'find invalid objects' feature instead of a 'build' on a database project in visual studio - so will keep an eye on this one as well. we've got the ball rolling on purchasing sql prompt licenses for everyone and I think, as a team, we will eventually abandon database projects in VS and go back to SSMS.

  ben_b March 05, 2018 10:44

  - 0 +
• 

  WindyCityGirl said:

  Hello Aaron,
  
  I would also like this feature. As part of our production deployment process I would like to be able to confirm via a SQL statement that there are no-invalid objects in *ANY* of the production user databases. If there was an output which confirmed the results that we could keep for SOC purposes (i.e. Database Name checked and the results) that would be very helpful. Right now i have to do each data base one at a time and take a screen print for the documentation and this is time consuming.
  
  Thank you!

  I am also trying to achieve the same goal. We have 3 environments with a lot of databases and this would be very helpful. 
  Is there any known workaround or progess since 2018?
  
  Thank you in advance

  Raynald January 24, 2022 13:49

  - 0 +
• 
  Hi @Raynald
  
  Thanks for your comment on this. 
  
  I'm engaging with our development to get an update on this. I will come back to you again as soon as possible.

  Dan_J February 04, 2022 15:13

  - 0 +
• 
  Hi @Raynald,
  
  Unfortunately this functionality had not yet been added, I have however re-highlighted this to our development team for their visibility.
  
  There has also been a feature request raised for this - https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/42693359-find-invalid-objects-in-multiple-databases. It would be good if you comment and/or vote for as this will further help to raise awareness of it.
  
  

  Dan_J February 07, 2022 10:06

  - 0 +
• 
  Hi @Dan_J
  Thank you very much for your answer

  Raynald February 07, 2022 10:24

  - 0 +

Add comment

Please sign in to leave a comment.