SQL | How to send Email from SQL Server ? Database Notifications

In this SQL Tutorial, we write SQL statements to send a database notification email through SQL Server.

If you need to configure your gmail id for the database notifications, then you will need to create an App Specific password in Gmail and use that password in the SQL Server. Please follow below steps to create the App Specific password.

Go to Gmail account settings , and click on security tab
Add 2 step verification (if you don't have)
Click on "App Password"
Select application device or add new one (Select 'Other' when it askes you to select an app you want to connect to, then enter in whatever name you want to give the app and generate a
new password.)
You will get new password to use in your app

Must Do Data Analytics Certifications -

Google Data Analytics Professional Certificate
https://imp.i384100.net/OR37oQ

Google Advanced Data Analytics Professional Certificate
https://imp.i384100.net/eK1WmQ

Please do not forget to like, subscribe and share.

For enrolling and enquiries, please contact us at
Website - http://knowstar.org/
Instagram -   / learn.knowstar  
Blog - http://know-star.blogspot.com/
Facebook -   / knowstartrainings  
Linkedin - https://www.linkedin.com/company/know...
Email - [email protected]