My method is taking advantage of having 2 physical monitors, (switch this up the way you choose) so the left monitor is for SSMS into Production or Pre-Prod ONLY and...

Thanks for the super quick response Gail

Hey,

Just a word of caution with using a trigger to send the email, I have been burnt in the past with this method. I would suggest writing the information you...

Hey,

Just came across the same error and realised a had a 'SET DATEFIRST' after the cursor was decalred. Moved this to the top of the SP and and now it...