Is there a way to command line automate SQL Prompt to

Script it to check every database via the 'Invalid Objects' report and email the output off to a user?

I love using this - but the time to slug through each database is a bit imposing.

I would think I could command like this to run against every DB and email the output to an emial group.

Is this possible?

Doug

SignantOzzie July 13, 2021 13:07

Comments

1 comment

Hi SignantOzzie

This is not currently possible within SQL prompt. however there is a uservoice request for this so I would suggest adding your name to that, https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/42693359-find-invalid-objects-in-multiple-databases

ATurner July 15, 2021 11:08

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Is there a way to command line automate SQL Prompt to

Comments

Add comment