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

Google Advanced Data Analytics Professional Certificate

Please do not forget to like, subscribe and share.

For enrolling and enquiries, please contact us at

[AbhishekKumar-gfdb]

Very very knowledgeable video.
Thanks mam for valuable efforts

[dkentertainments]

Can you please explain how to use XMLAGG in SQL with realtime examples?

[mazooths]

I don't have such database mail option in my sql server. I'm using sql server management studio 2022. what can i do? please reply

[sriram]

Mam, can you show how to send mail with attachment

[victorstecenko]

How to set up a mail profile to send mail through an external server using IMAP protocol ?