Send Email from SQL Server (Stored Procedures): SQL Express

[@akhilareddy8231]

Thanks for your video 👍🏻

[@DataVids]

My pleasure! Thanks for watching.

[@akhilareddy8231]

Thanks :)

[@coolcobra2588]

Hi, by any chance, how can I make this work after "Less Secure Apps" was removed?

[@DataVids]

Less secure apps I believe only applies to gmail. You can still use database mail with another smtp provider. If you want to keep using gmail it looks like there are some settings you can change around to make the 2 step verification work, and this can work with database mail. Check out this article: support.google.com/accounts/thread/165730996?hl=en&msgid=165769204

[@FIRST-hr9yr]

@@DataVids can you update this video so it works with a different smtp provider? I cannot get it to work.

[@FIRST-hr9yr]

@@DataVids or at least share the script that works with a non-gmail provider

[@akhilareddy8231]

Thanks for your video 👍🏻