Is there a way to command line automate SQL Prompt to
SignantOzzie
Posts: 6 Bronze 1
in SQL Prompt
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
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
Tagged:
Answers
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