terry.home (3/28/2015)
Thanks for sharing the script.Whilst I appreciate what you are doing and that you have shared your script, I am just wondering if it is not simpler and safer to simply setup SQL Reporting report and then subscribe to it?
T
For our purposes, we have maybe a hundred little checks set up to maintain consistency of data across multiple third party software platforms. Could we set each up in SSRS? Yes, definitely. However since this is internal reporting, usually just to the DBA team, it is easier to use the shown stored procedure.